Which of the following criterion expressions searches for a State field that is equal to Ca?
A)=Ca
B)="Ca"
C)=(Ca)
D)=#Ca#

Question

Quizplus · Accepted Answer

The correct syntax for searching a text field for a specific value in many database query languages, including SQL, is to enclose the value in double quotes. Therefore, "Ca" is the correct format to search for entries where the State field is equal to "Ca".

Which of the Following Criterion Expressions Searches for a State