Srinivas Srinivas - 5 months ago 13
SQL Question

Searching for strings with double quotes in sql server

I want to find out all rows that have a double quotes character in a particular field.

I am trying something like

charindex(columnname,'""')
in the
where
clause, but it does not seem to work.

Any help will be much appreciated.

Answer

I would suggest you use a like statement

Where field Like '%""%'
Comments