Re: How do I insert a string with a single quote

insert into tmp values ('table''s');

Not a double quote, but two single quotes.

cheers,
cindy

anurag wrote:

> Hi,
> I am trying to insert a string with a single quote inside, but
> it fails. Please advise how do I tackle this problem.
>
> eg:- insert into tmp values ('table's');
> I am not supposed to change the single quote to a double quote
> for eg: insert into tmp values ('table"s');
>
> Thanks
> Anurag
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
> The fastest and easiest way to search and participate in Usenet - Free!
Received on Sat Mar 18 2000 - 00:00:00 CST