Re: Caret problem
Paul Lautman 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?
>
>
did you try lower case t in '%^\t%'
also try using back ticks ` to see if you notice any difference. it's
the character below ~
|