The following SELECT statement: SELECT *
FROM tblCustomers
WHERE LastName Like "smith";
Would list ________.
A)all customers first and last names from tblCustomers with a last name that begins with "smith"
B)all fields from tblCustomers with a last name that begins with "smith"
C)all fields from tblCustomers where the customers' last name is "smith"
D)all fields from tblCustomers where the customers' last name contains "smith"

Question

Quizplus · Accepted Answer

The LIKE operator with "smith" (without any wildcard characters) will match records where the LastName is exactly "smith".

The Following SELECT Statement: SELECT