Biology Forums - Study Force

Other Fields Homework Help Management Topic started by: riz on Jan 31, 2018



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