× Didn't find what you were looking for? Ask a question
Top Posters
Since Sunday
o
5
5
b
4
s
3
j
3
b
3
m
3
K
3
g
3
L
3
w
3
m
3
Home Q & A Board Other Fields Homework Help Business Management
New Topic  
riz riz
wrote...
Go to Answer
Posts: 694
Rep: 0 0
6 years ago
Based upon the contents of the ORDERS table, which of the following will display the shipping location as: Shipcity, Shipstate Shipzip
 a. SELECT INITIALCAP(CONCAT(shipcity, shipstate, shipzip))FROM orders;
  b. SELECT INITCAP(CONCAT(shipcity, CONCAT(', ', CONCAT(shipstate,CONCAT(' ', shipzip)))))FROM orders;
  c. SELECT INITCAP((CONCAT(shipcity, shipstate, shipzip))FROM orders;
  d. SELECT INITCAP(CONCAT(shipcity, CONCAT(', ', CONCAT(shipstate,CONCAT(' ', CONCAT(shipzip))))))FROM orders;
Read 49 times
1 Reply
Replies
Answer verified by a subject expert
unique101unique101
wrote...
#1
Top Poster
Posts: 917
Rep: 5 0
6 years ago
Sign in or Sign up in seconds to unlock everything for free
1

Related Topics

riz Author
wrote...

6 years ago
this is exactly what I needed
mmmm_dat_userna
wrote...

Yesterday
Just got PERFECT on my quiz
ethom947
wrote...

2 hours ago
Correct Slight Smile TY
New Topic      
Quick Reply
Explore
Post your homework questions and get free online help from our incredible volunteers
  951 People Browsing
 112 Signed Up Today
Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook
Live Chat
Related Images
  
 372
  
 1076
  
 314
Your Opinion
Which industry do you think artificial intelligence (AI) will impact the most?
Votes: 405
Previous poll results: Which industry do you think artificial intelligence (AI) will impact the most?