Operators for LIKE Flashcards
1
Q
what does this operator search for WHERE CustomerName LIKE ‘a%’?
A
finds any values that start with A
2
Q
What does this operator search for WHERE CustomerName LIKE ‘%a’
A
finds any values that end with A
3
Q
What does this operator search for WHERE CustomerName LIKE ‘%or%’
A
finds any values that have OR in any position
4
Q
What does this operator search for WHERE CustomerName LIKE ‘_r%’
A
finds any values that have R in the second position
5
Q
What does this operator search for WHERE CustomerName LIKE ‘a_%_%’
A
finds any values that starts with A and are at least 3 characters in length
6
Q
What does this operator search for WHERE ContactName LIKE ‘a%o’
A
finds any values that starts with A and ends with O
