Hi All
I have one text field and the user has enetered single quotation in the data, and in the query it gives error.
I want to know 2 things
1) select statement to find out those records where there is single quotation mark in the text field.
2)How to prevent the error of the query, even if the data enetered has single quote marks


Thanks

Regards