My problem is the following:

 I am trying to construct an Insert statement at server side using input by the user. I am allowing the user to enter 'Memo' using a multi-line text box. The insert statement works fine for whatever the user enters except when he enters an " ' " as I am constructing insert statement using a string variable. The ADO is interpreting the " ' " to be the end of Insert statement.

How to solve this?

Sanket