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 start with the letter "e".
D) all strings in the Name column whose second letter is an "e".

Question

Quizplus · Accepted Answer

The underscore (_) is a wildcard for a single character, so '_e%' matches any string where the second character is 'e'.

What Will the Following Expression Match To? Name LIKE '_E