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 '%'%'

Answer 1

Just need to escape it.

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