Re: Single quote?
From: Avi Abrami <aabrami_at_intersystemsww.com>
Date: Thu, 01 Mar 2001 13:01:03 +0200
Message-ID: <3A9E2BEF.56EF543F_at_intersystemsww.com>
Date: Thu, 01 Mar 2001 13:01:03 +0200
Message-ID: <3A9E2BEF.56EF543F_at_intersystemsww.com>
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!
Hi Peta,
The following query
SELECT column
FROM table
WHERE column LIKE '%''%'
will return rows where the value of "column" contains a single quote.
HTH,
Avi.
Received on Thu Mar 01 2001 - 12:01:03 CET