Home » MCQs » SQL MCQs » SQL Pattern Matching MCQs

What does the following statement do (3)?

9. 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 start with "a" and are at least 2 characters in length
4. All of the above

Answer: C) Finds any values that start with "a" and are at least 2 characters in length

Explanation:

The above statement finds any values that start with "a" and are at least 2 characters in length