searching for quote (") in an iSQL statement

[punchykool]

Hello,

trying to find a double-quote (") in a varchar field.
How do we do this?

I have tried these, but obviously there are three sets of quotes and it doesn't like that. Aside from unloading the table and using other tools to find it, can we comment out the quote so it will return those matching the criteria?

select * from tocs where toc_name like "%"%"
select * from tocs where toc_name like "%\"%"

 

[olded]

Hi:

Try the matches keyword using single quotes:

select * from tocs where toc_name matches '*\"*'

At least on solaris 7 system running 7.31 online, the \ is optional.

Regards,


Ed

 

[punchykool]

excellent! Thanks again, Ed.
And I discovered that wrapping the string in double-quotes will allow me search for two single-quotes in my data.

select * from tocs where toc_name matches "%'%'%