SQL Server: How to call a string with apostrophe in name

Question

WHERE Variable = 'Lowe's';

But string is ending at Lowe because it recognizes the 's as end of String.

How to circumvent this?

http://stackoverflow.com/questions/9596652/how-to-escape-apostrophe-in-mysql — Vinicius Lima, Jul 30 '13 at 17:16
http://stackoverflow.com/questions/17953257/sql-server-how-to-call-a-string-with-apostrophe-in-name — Vinicius Lima, Jul 30 '13 at 17:17

score 4 · Answer 1 · answered Jul 30 '13 at 17:13

4

Use two '

WHERE Variable = 'Lowe''s'

SQLFiddle demo

answered Jul 30 '13 at 17:13

juergen d

195,137
36
275
343

score 2 · Answer 2 · answered Jul 30 '13 at 17:24

2

Although escaping ' with '' works, in case you are running this command from any application you should take a look at databinding and using SqlParameters - spares you a lot of headache, improves performance and security.

answered Jul 30 '13 at 17:24

Linky

595
7
23

SQL Server: How to call a string with apostrophe in name

2 Answers2

SQLFiddle demo