From: Warren Brown <warrenbrown@...>
Date: 2006-01-05T10:41:56+09:00
Subject: Re: Uploading data to MS SQL Server - problem with quote character

Sam,

> I need to upload data coming from Oracle database to
> an MS SQL Server.  But I'm having problems inserting
> if data contains a quote (') character.

    On most all modern databases, a single quote must be quoted with
another single quote.  For example, to update a value to the string "I
don't know":

UPDATE mytable SET mystring = 'I don''t know.'

    I hope this helps.

    - Warren Brown