Searching for quotation marks in WHERE clause

[eerich]

Is it possible to search for quotation marks using the LIKE clause in the WHERE statement. I have a field that is not parsing correctly because some of the records contain " " marks. I would like to identify just these fields, but when I construct the SQL I'm not able to include the quotation in the search. Example of my query:

Select *
From myTable
WHERE name like "*'"'";

I've tried variations of this by putting the quotation in brackets but nothing seems to work.

Any help is appreciated.

 

[PHV]

For single quotes:
WHERE name like "*'*"

For double quotes:
WHERE name like '*"*'

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[eerich]

That worked!

Thanks.