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.
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 '%"%"%'
Try this.
SELECT * FROM tb WHERE col Like '%"%'
Or
SELECT * FROM tb WHERE CHARINDEX('"',col) > 0
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With