Re: Caret problem On 14 May, 14:32, lark <ham...@sbcglobal.net> wrote:
> 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%'
Why woluld I want a ower case t?
>
| also try using back ticks ` to see if you notice any difference.
it's
| the character below ~
On your keyboard it may be but not on mine.
And I thought that back ticks were reserved for quoting identifiers,
so why would I want to quote a literal with backticks?
Please explain |