Thread: Caret problem
View Single Post

   
  #4 (permalink)  
Old 02-28-2008, 10:49 AM
subtenante
 
Posts: n/a
Default Re: Caret problem

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]%' ?
Reply With Quote