× Didn't find what you were looking for? Ask a question
Top Posters
Since Sunday
L
4
d
4
3
k
3
k
3
j
3
k
3
b
3
f
3
b
3
d
3
h
3
Home Q & A Board Other Fields Homework Help Business Management
New Topic  
EnS0urce EnS0urce
wrote...
Go to Answer
Posts: 680
Rep: 0 0
6 years ago
Based upon the contents of the CUSTOMERS table, which of the following will display the shipping location as: City, State Zip
 a. SELECT INITCAP(CONCAT(city, CONCAT(', ', CONCAT(state,CONCAT(' ', zip)))))FROM customers;
  b. SELECT CONCAT(city, CONCAT(', ', CONCAT(state,CONCAT(' ', CONCAT(zip)))))FROM customers;
  c. SELECT INITCAP(CONCAT(city, ', ', state, ' ', zip))FROM customers;
  d. none of the above
Read 54 times
1 Reply
Replies
Answer verified by a subject expert
Ha d.Ha d.
wrote...
#1
Top Poster
Posts: 876
Rep: 3 0
6 years ago
Sign in or Sign up in seconds to unlock everything for free
1

Related Topics

EnS0urce Author
wrote...

6 years ago
You make an excellent tutor!
jmelchor77
wrote...

Yesterday
Thanks
SUmmerPeople
wrote...

2 hours ago
Good timing, thanks!
New Topic      
Quick Reply
Explore
Post your homework questions and get free online help from our incredible volunteers
  1020 People Browsing
Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook
Live Chat
Related Images
  
 816
  
 603
  
 278
Your Opinion
Which 'study break' activity do you find most distracting?
Votes: 820
Previous poll results: Do you trust social media networks with protecting your privacy?