Sergey Filatov wrote:
>
> Greetings.
>
> My problem is to find percent character in some field.
> I'm wonder how specify percent character or other wildcard characters
> in 'LIKE patterns'?
>
> Many thanks in advance,
> Sergey.
You have escape them with the backslash. In order to pass the backslash
to the backend you have to escape the backslash as well:
select * from xxx where yyy like '\\%';
It might be a good idea to point this out in the Postgresql book :-)
With kind regards,
Holger Klawitter
--
Holger Klawitter
[EMAIL PROTECTED] http://www.klawitter.de
