Wildcard for single characters

Question

When you use the underscore for a comparison of string in the where statement, you only use it for a single character. I was wondering if you have this statement:
WHERE name LIKE 'a_b'
Will it gather data like 'ab', or do you have to have a single character between a and b for it to be true? If that's true, why?

Answer 1

Colton Minard in general it should pick up at 'a' and then a single character and then 'b'. It should not pick up say words like able or stable or label. The wildcard says there is a letter or number in this case for product identification as 'a1b' or 'azb' given that this is pattern matching ...