What will the following expression match to?
Name LIKE '%e%'
A)all strings in the Name column that end with "e".
B)all strings in the Name column whose second to last letter is an "e".
C)all strings in the Name column that contain the letter "e".
D)all strings in the Name column whose second letter is an "e".

Question

Quizplus · Accepted Answer

The expression "LIKE '%e%'" means that we are looking for any string in the Name column that contains the letter "e" anywhere in it. So option C is correct. Option A would match only strings that end with "e" while option B would match only strings with an "e" as the second to last letter, neither of which is what the expression is looking for. Option D would match only strings whose second letter is an "e", which is not what the expression is looking for.

What Will the Following Expression Match To