sqlsql-server

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.

Solution

  • If there is only one double quote then you should try

    select * from tablename where columnname like '%"%'

    If you know that there are two consecutive double quotes then, I would suggest you to use a like statement

    select * from tablename where columnname like '%""%'

    Otherwise if you don't know then you should try(Which is more preferable)

    select * from tablename where columnname like '%"%"%'