Saving Text with special character into SQL Express table

Hi, fellows!

When I need to save a text into a SQL Express table I use the character ' to encote the text. (ex: 'myText' )

How to procedure when the text has already the character ' ? (ex: how to enconte the text Color's car ) ?

Many thanks to any kind of help!

Using a INSERT / UPDATE Script you will have to double quote it:

INSERT INTO SomeTable(SomeColumn)
VALUES('Jens''s')

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||Many thanks, Jens!