/ All posts
- M9 - LIKE operator with (
Just ran into something a little puzzling. I'm trying to match a string that contains a '(', but the LIKE operator returns false. If I run this in the command window:
values ('abbc' LIKE 'ab%','a(bc' LIKE 'a(%' )
I get true, false. All have have done is replaced the second character with a '(' in the string and the pattern. Why is the second value false?
I couldn't find anything in the documentation to say that '(' is a special character, and escaping with a '\' didn't appear to help.
Does anyone know what is causing this behaviour?
Thanks Adam, I got the same behaviour with "[" and closing braces.