Re: Single quote?
From: Matt B. <mcb_at_ds.znet.com>
Date: Wed, 28 Feb 2001 20:40:35 -0800
Message-ID: <t9rlgkb8q68mc3_at_corp.supernews.com>
Date: Wed, 28 Feb 2001 20:40:35 -0800
Message-ID: <t9rlgkb8q68mc3_at_corp.supernews.com>
"Peta Griffith" <peta_at_dataspeed.com.au> wrote in message
news:3Yen6.5626$v5.20954_at_newsfeeds.bigpond.com...
> Does anyone know how you look for a single quote in a text field? (do you
> place other quotes around it?)
>
> Thanks!
Yes - put an extra single quote in your query to "escape" it.
e.g.:
select 'people''s' from dual
...will give people's as a result
-Matt Received on Thu Mar 01 2001 - 05:40:35 CET