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".