Title: Based upon the contents of the ORDERS table, which of the following will display the shipping ... Post by: riz on Jan 31, 2018 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; Title: Based upon the contents of the ORDERS table, which of the following will display the shipping ... Post by: unique101 on Jan 31, 2018 Content hidden
|