I am trying to insert values into a database, from a textbox. I do not wish to use the adodc.recordset.fields command, but would rather prefer to enter it using the -Insert Values in SQL.

This works correctly, until I try insert a string containing = or > or ' or any other such character types. What is the correct syntax to insert such characters into SQL ?

thanks