Handling single quotes in data and SQL

Hello all,

We have been having problems with data that contains single quotes (as an apostrophe) in text fields (for example a name field or a notes field). This causes problems when we attempt to create SQL statements from our application, since the quote appears as a string-creating character, and mess up the rest of the SQL statement.

Is there a typical strategy that people use to get around such problems?

Thanks for any hints,
Dean Received on Thu Apr 20 2006 - 09:01:25 CDT