Problem in meta character into data

[prriya pratheep]

Hi

I want to check against meta data in my query

I have one table with one record with single quote.I want to select all the records without this record contains single quote value

i wrote select * from tab where filename='xxx'' so i am getting error.can anybody help me to sort out this prob

thanks

[Paul Sturrock]

Use a PreparedStatement. That way you don't have to worry about special characters.