Caret problem

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?

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 ~

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

On Sun, 13 May 2007 22:23:14 +0100, "Paul Lautman"
<paul.lautman@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]%' ?

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.

Captain Paralytic wrote:
> 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
>
you're right! back ticks are only for quoting identifiers!

--
lark -- hamzee@sbcdeglobalspam.net
To reply to me directly, delete "despam".

On 14 May 2007 07:50:34 -0700, Captain Paralytic
<paul_lautman@yahoo.com> wrote:

>> >Any ideas?
>>
>> LIKE '%/[^\\\\d]%' ?
>
>I'll try that later and let you know.

I'm curious. Did it work ?