Subscribe to this thread
Home - General / All posts - M9 - LIKE operator with (
mlinth
441 post(s)
#17-Nov-20 09:47

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,

Martin

adamw


9,445 post(s)
#30-Nov-20 13:39

This is a bug. The second LIKE should return TRUE as well. We will fix it.

Thanks!

mlinth
441 post(s)
#30-Nov-20 15:10

Thanks Adam, I got the same behaviour with "[" and closing braces.

adamw


9,445 post(s)
#30-Nov-20 15:23

Yes, as well as with some other characters. This all is the same issue.

Manifold User Community Use Agreement Copyright (C) 2007-2019 Manifold Software Limited. All rights reserved.