Home » MCQs » SQL MCQs » SQL Pattern Matching MCQs

What does the following statement do (4)?

10. What does the following statement do?

WHERE ContactName LIKE 'a%o'

1. Finds any values that start with "a" and ends with "o"
2. Finds any values whose first character is "a" and third character is "o"
3. Both A. and B.
4. None of the above

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

Explanation:

The above statement finds any values that start with "a" and ends with "o"