Michael MacFadden <[EMAIL PROTECTED]> writes:
> I am trying to insert some text into a table, but the text has some quote
> characters in it. For example, lets say I have the following table.
>
> Performing the following insert won't work:
>
> INSERT INTO test ( col2 ) VALUES ('This doesn't work');
Escape single quotes in the string with two single quotes:
INSERT INTO test ( col2 ) VALUES ('This didn''t work but now does');
Derrell
