/* *** *** */ SELECT ShipmentID, ShipperName, ShipperInvoiceNumber, ArrivalDate FROM SHIPMENT DepartureDate LIKE '12%'; However, Microsoft Access uses the wildcard *, gives the following SQL statement: /* *** SQL-Query-MI-E-Access *** */ SELECT ShipmentID, ShipperName, ShipperInvoiceNumber, ArrivalDate FROM SHIPMENT WHERE DepartureDate LIKE '12*'; Assume DepartureDate and ArrivalDate are in the format MM/DD/YY. List the ShipmentID, ShipperName, and ShipperInvoiceNumber and ArrivalDate of all shipments that departed on the tenth day of any month. Solutions to Morgan Importing questions are contained in the Microsoft Access database which is available in the Instructor’s Resource Center on the DBP-e13-IM-CH02-MI.accdb text’s Web site (). The correct SQL-92 statement, which uses the wildcards % and _, is: /* *** SQL-Query-MI-F *** */ SELECT ShipmentID, ShipperName, ShipperInvoiceNumber, ArrivalDate FROM SHIPMENT WHERE DepartureDate LIKE '___10%'; However, Microsoft Access uses the wildcards * and ?, give the following SQL statement: /* *** SQL-Query-MI-F-Access-A *** */ SELECT ShipmentID, ShipperName, ShipperInvoiceNumber, ArrivalDate FROM SHIPMENT WHERE DepartureDate LIKE '???10*'; Further, Microsoft Access does NOT show the leading zero in MM, so we must add a compound WHERE clause to get months without the leading zeros: /* *** SQL-Query-MI-F-Access-B *** */ SELECT ShipmentID, ShipperName, ShipperInvoiceNumber, ArrivalDate FROM SHIPMENT WHERE DepartureDate LIKE '???10*' OR DepartureDate LIKE '??10*';
/* *** *** */ SELECT ShipmentID, ShipperName, ShipperInvoiceNumber, ArrivalDate FROM SHIPMENT DepartureDate LIKE '12%'; However, Microsoft Access uses the wildcard *, gives the following SQL statement: /* *** SQL-Query-MI-E-Access *** */ SELECT ShipmentID, ShipperName, ShipperInvoiceNumber, ArrivalDate FROM SHIPMENT WHERE DepartureDate LIKE '12*'; Assume DepartureDate and ArrivalDate are in the format MM/DD/YY. List the ShipmentID, ShipperName, and ShipperInvoiceNumber and ArrivalDate of all shipments that departed on the tenth day of any month. Solutions to Morgan Importing questions are contained in the Microsoft Access database DBP-e13-IM-CH02-MI.accdb which is available in the Instructor’s Resource Center on the text’s Web site (). The correct SQL-92 statement, which uses the wildcards % and _, is: /* *** SQL-Query-MI-F *** */ SELECT ShipmentID, ShipperName, ShipperInvoiceNumber, ArrivalDate FROM SHIPMENT WHERE DepartureDate LIKE '___10%'; However, Microsoft Access uses the wildcards * and ?, give the following SQL statement: /* *** SQL-Query-MI-F-Access-A *** */ SELECT ShipmentID, ShipperName, ShipperInvoiceNumber, ArrivalDate FROM SHIPMENT WHERE DepartureDate LIKE '???10*'; Further, Microsoft Access does NOT show the leading zero in MM, so we must add a compound WHERE clause to get months without the leading zeros: /* *** SQL-Query-MI-F-Access-B *** */ SELECT ShipmentID, ShipperName, ShipperInvoiceNumber, ArrivalDate FROM SHIPMENT WHERE DepartureDate LIKE '???10*' OR DepartureDate LIKE '??10*';
Solution-Manual-for-Database-Processing-Fundamentals-Design-and-Implementation-13E-13th-Edition.docx