How to SQL Query text access a Single quotes/apostrophes with "IN" operator?

Asked Mar 14 '20 at 05:57

Active Mar 14 '20 at 05:57

Viewed 16 times

I'm trying to insert some text data into a table in SQL Server. The text includes a single quote(') like (New CCTest's,Test Security's..).

I am using IN operator in where query like below.

SELECT * FROM CostCenters acc WHERE acc.CCName IN ('New CCTest's','Test Security's')

but it throw me errors : Incorrect syntax near 's'.

Also I have tried using double quotes, but it threw me some errors.

SELECT * FROM CostCenters acc WHERE acc.CCName IN ('New CCTest"s','Test Security"s')

How do I escape that?

asked Mar 14 '20 at 05:57

Arvind Sisara

Just duplicate the single quotes: `SELECT * FROM CostCenters acc WHERE acc.CCName IN ('New CCTest''s','Test Security''s')` – Nick Mar 14 '20 at 05:58
or use a backshash `\'` – juergen d Mar 14 '20 at 05:59

0 Answers0