escape character 1

[link9]

Hello all --

Easy one for you, I'm sure:

What's the T-SQL escape character, like if I wanna execute this statement:

INSERT INTO tableName (column) VALUES ('paul's corner')

How do I do it?

Thanks -
paul

 

[tlbroadbent]

You don't use an escape character. Just use two single quotes.

INSERT INTO tableName (column) VALUES ('paul''s corner') Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[link9]

thx