How do I insert a string with a single quote

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!