Re: BUG #5535: Backslash in condition for LIKE statement is not seen

Thanks, that works!

On Jul 1, 2010, at 1:34 PM, Kevin Grittner wrote:

> "Jeff Benjamin" <jeff@ivertex.com> wrote:
>
>> Seems one cannot use a backslash character in a LIKE condition.
>
> By default that has special meaning as an escape character.
>
> Try this:
>
> select * from test where pattern like E'\\w%' escape '#';
>
> or this:
>
> select * from test where pattern like E'\\\\w%';
>
> -Kevin