Re: Caret problem
On 14 May, 15:43, subtenante <zzsubtenant...@gmail.com> wrote:
> On Sun, 13 May 2007 22:23:14 +0100, "Paul Lautman"
>
> <paul.laut...@btinternet.com> wrote:
> >I needed to locate rows that contained
> >/[^\d]
>
> >Whilst
> >LIKE '%/[^%'
> >worked fine
> >LIKE '%/[^\d%' ESCAPE '@'
> >or even '%^\T%'
> >found nothing.
> >I tried escaping various parts, but if I had a character following the ^,
> >nothing was found.
>
> >Any ideas?
>
> LIKE '%/[^\\\\d]%' ?
I'll try that later and let you know.
|