Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Searching for strings with double quotes in SQL Server

Tags:

sql

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.

like image 320
Srinivas Avatar asked Jul 01 '16 10:07

Srinivas


2 Answers

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 '%"%"%'
like image 71
Chris J Avatar answered Oct 19 '22 07:10

Chris J


Try this.

SELECT * FROM tb WHERE col Like '%"%'

Or

SELECT * FROM tb WHERE CHARINDEX('"',col) > 0
like image 35
taotechnocom Avatar answered Oct 19 '22 08:10

taotechnocom