Does any one know how can I find the character "%" in a string using "Like".
Normaly the "%" is a wild-card character.
Thanks.
Printable View
Does any one know how can I find the character "%" in a string using "Like".
Normaly the "%" is a wild-card character.
Thanks.
You should use escape character:
SELECT last_name FROM employees
WHERE last_name LIKE '%A\_B%' ESCAPE '\';