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 B.