inserting single quotes

[Jesper F]

How can I insert text into a table when the text contains single quotes
within the SQL-statement?
I get an error when trying:
INSERT INTO tablename (field1,field2) VALUES ('testtext','Y'all')
What's the workaround for this?
Thanks.

 

[Ken Snell [MVP]]

You need to double up the single quotes in the string. You can do this by
using the Replace function. Check it out in Help and post back if you have
questions.

 

[John Vinson]

How can I insert text into a table when the text contains single quotes
within the SQL-statement?
I get an error when trying:
INSERT INTO tablename (field1,field2) VALUES ('testtext','Y'all')
What's the workaround for this?
Thanks.

Double up the apostrophes, or delimit the strings with " instead of ':

INSERT INTO tablename (field1, field2) VALUES ('testtext', 'Y''all')

or

INSERT INTO tablename (field1, field2) VALUES ("testtext", "Y'all")

The " delimiter works in Access JET syntax, but not (I believe) in
SQL/Server's dialect.

John W. Vinson[MVP]

 

[Jesper F]

Double up the apostrophes, or delimit the strings with " instead of ':

Thanks a lot to both of you.