How do I code my program so that if a user enters a single quote in a string value that I have to pass as a SQL statement, there will be no ODBC error.

like "David's" ... it come back with an odbc invalid format error.


Thanks