Thread: Caret problem
View Single Post

  #5 (permalink)  
Old 05-14-2007
Captain Paralytic
 
Posts: n/a
Default 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.

Reply With Quote