Click here to subscibe to newsletter

Text with single quote


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

Posted by Matthy 84.81.208.61 on November 18 2005 14:36:22:

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

* : (Required)

* Name:
E-Mail:

* Subject:

* Comments:

Optional Link URL:
Link Title:
Optional Image URL:

Enter the code shown :


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

Copyright © 1999-2004 David Birebent All Rights Reserved.