Home » MCQs » SQL MCQs » SQL Pattern Matching MCQs

What does the following statement do?

6. What does the following statement do?

WHERE CustomerName LIKE 'a%'

1. Finds any values that start with "a"
2. Finds any values that start with "a%"
3. Finds any values that contains only two characters starting with "a"
4. All of the above

Answer: A) Finds any values that start with "a"

Explanation:

The above statement finds any values that start with "a"