The OP hijacked a thread and provided no subject: Nathan - you can do
better than this!


Nathan Jobe wrote:

> How do you add a literal % sign to your SQL queries and not have it take as
> a wildcard ?
>
> My users want to be able to search for 1% without coming with all things
> that contain or end in 1
>

Use the ESCAPE clause

... | VALUE [NOT] LIKE <val> [ESCAPE <val>]


I haven't seen this used lately (or an example in the docs) so I've no
further info.

--
Aage J.