Re: Escape wildcard problems.

On Friday 24 October 2008, "Gauthier, Dave" <dave.gauthier@intel.com> wrote:
> I read in the docs (section 9.7.1) that the backslash... \ ... is the
> default escape char to use in "like" expressions.  Yet when I try it, it
> doesn't seem to work the ay I expect.  Here's an example...
>
> select name from templates where name like '%\_cont\_%';
>

Use double \\ for underscores. I don't know why it's necessary, but it works
here.


--
Alan