Hi,
I've been using pattern matching with wildcards, and encountered an issue when dealing with the underscore character. The issue is that if it is placed at the end of the string, the "_" behaves like a "*".
For example, if I have a query
SELECT * FROM table1 WHERE (col1.name LIKE "ke_")
It matches both "key" and "keyboard"
Having the underscore anywhere else works fine, however.
Thanks