Thread: Caret problem
View Single Post

   
  #3 (permalink)  
Old 02-28-2008, 09:49 AM
Captain Paralytic
 
Posts: n/a
Default 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

Reply With Quote