Re: Single quote?
From: cedric le bot <cedric.le-bot-renexter_at_renault.com>
Date: Thu, 01 Mar 2001 10:13:11 +0100
Message-ID: <3A9E12A7.55C4B13D_at_renault.com>
Date: Thu, 01 Mar 2001 10:13:11 +0100
Message-ID: <3A9E12A7.55C4B13D_at_renault.com>
nick a écrit :
>
> Peta Griffith wrote:
> >
> >
> > Does anyone know how you look for a single quote in a text field? (do
you
> > place other quotes around it?)
> >
> > Thanks!
> >
[Quoted]
> > trying using the wildcard command to find the single quote...
>
> try something like this: SELECT column_name
> FROM table
> WHERE column_name like '%'%';
> i'm not sure if it'll work,but give it a shot..
I think you have forgotten a single quote between the %. Try this : SELECT column_name
FROM table
WHERE column_name like '%''%';
>
> --
> Posted via CNET Help.com
> http://www.help.com/
Received on Thu Mar 01 2001 - 10:13:11 CET