I received this question in a Whizlabs
test, and I'm not sure I understand this right...
Select all
pattern values of a LIKE expression that would identify a
word starting with a 'J' and having 'on' as the last two characters.
[A] 'J%on_'
[B] 'J*on%'
[C] 'J%on*'
[D] 'J_on%'
[E] 'J%_on_'
They give the correct answer as A,E.
Quote: "The only way to identify words having 'on' as the last two characters is by having a
string that contains 'on' and an underscore, as in 'on_'.
However, I understood that '_' stands for any single character. Can it also stand for nothing?
Thanks,
Jeremy