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