Operators for LIKE

Question 1

what does this operator search for WHERE CustomerName LIKE ‘a%’?

Answer 1

finds any values that start with A

Question 2

What does this operator search for WHERE CustomerName LIKE ‘%a’

Answer 2

finds any values that end with A

Question 3

What does this operator search for WHERE CustomerName LIKE ‘%or%’

Answer 3

finds any values that have OR in any position

Question 4

What does this operator search for WHERE CustomerName LIKE ‘_r%’

Answer 4

finds any values that have R in the second position

Question 5

What does this operator search for WHERE CustomerName LIKE ‘a_%_%’

Answer 5

finds any values that starts with A and are at least 3 characters in length

Question 6

What does this operator search for WHERE ContactName LIKE ‘a%o’

Answer 6

finds any values that starts with A and ends with O