Home » MCQs » SQL MCQs » SQL Pattern Matching MCQs

What does the following statement do (2)?

8. What does the following statement do?

WHERE CustomerName LIKE '%or%'

1. Finds any values that start with "or"
2. Finds any value that contains only four characters and second, third characters are 'o', 'r'
3. Finds any values that have "or" in any position
4. None of the above

Answer: C) Finds any values that have "or" in any position

Explanation:

The above statement finds any values that have "or" in any position