Look for a % in a string with "like"

[Highlander]

Does any one know how can I find the character "%" in a string using "Like".
Normaly the "%" is a wild-card character.

Thanks.

[Shestakov]

You should use escape character:

SELECT last_name FROM employees
WHERE last_name LIKE '%A\_B%' ESCAPE '\';