Simply double the qoute mark.
INSERT INTO table (name) VALUES('John''s house is in Dalas');
On Sat, 14 Oct 2000, Thu Huynh wrote:
> Hello,
>
> Does anyone know how to insert/update data that contains single quote (')
> into a field? Data such as: John's house is in Dalas.
>
> I know one can insert double quote by using single quotes as field
> delimiters. But since I have to use single quotes as field delimiters, data
> cannot contain single quote. Is there a way to change the field delimiter?
>
> Thanks for your helps.
>
> Thu.
>
> _________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
> Share information about yourself, create your own public profile at
> http://profiles.msn.com.
>