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

in the
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 '%""%'
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download