SQL Special character

Question

I need to write a query where I need to find the ' character.

Like Shivam's - I need to find the ' mark.

select * from DTCountries where CountryCode like '%'%'

possible duplicate of [How do I escape a single quote in sqlserver?](http://stackoverflow.com/questions/1586560/how-do-i-escape-a-single-quote-in-sqlserver) — Conrad Frix, Jun 13 '12 at 18:29

score 11 · Answer 1 · answered Jun 13 '12 at 18:28

11

Just need to escape it.

SELECT * FROM DTCountries WHERE CountryCode LIKE '%''%'

answered Jun 13 '12 at 18:28

Kevin Fairchild

The other answer was accepted even though mine came in first (beat him by a whole second... lol), but I still appreciate the Upvotes everyone's been giving. And, yes, seems like a dupe question. – Kevin Fairchild Jun 18 '12 at 16:55

score 7 · Accepted Answer · edited Jun 14 '12 at 15:02

7

Double it up

select * from DTCountries where CountryCode like '%''%'

edited Jun 14 '12 at 15:02

tomfanning

answered Jun 13 '12 at 18:29

SQLMenace

2 Answers2