Re: Text with single quote

[ Follow Ups ] [ Post Followup ] [ SQL Script Builder Forum ]

Posted by Dave on December 11 2005 20:10:08:

In Reply to: Text with single quote posted by Matthy on November 18 2005 14:36:22:

Version 1.4 is released today, it now support single quotes in text fields.

> A table contains a single quote.
> Building the script, this text is extracted as is.
> This results in the following command:
> VALUES ('12661','SLOAN'S BALSEM','SLOAN'S BALSEM','108','M02AC','0','False')
>
> Running the script give the error:
> Line 21969: Incorrect syntax near 'S'.
>
> How to handle single quotes in text?

Follow Ups:

Post a Followup