Srinivas Srinivas - 1 year ago 74
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 Source

I would suggest you use a like statement

Where field Like '%""%'