How to filter out the double quotation from a field by using SQL

[Guest]

I would like to filter out the cells with double quotation mark within a
specify column by using SQL statement. However, as double quotation mark (")
is used as to specify textual criteria expression, therefore, it is not
possible to use """ in my statement, as this statement will become invaild.

 

[Douglas J. Steele]

Try either

WHERE MyField LIKE '*"*'

or

WHERE MyField LIKE ""*""*""