I have a form in VFP which allows the user to enter notes. The notes are store in vfp cursors and then sent to the sql server database.

The field type that I use in SQL Server to save the note is of type Text.
The problem is that will not allow me to save words within a quotation mark.
For example : "civil".

If I remove the quotation mark I am able to save without a problem.

Here is the error that I get :

Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near "civil".ODBC Error Message: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near "civil".ODBC SQL state: 37000ODBC data source Error #: 170ODBC Connection Handle: 1

Does anybody know how to solve this problem?

Thanks,
Sergio