I am using the following code in my pages"


VALUE = request.form("user_input")

Var_insert = "Insert into TABLE values (" + VALUE +")"

set rsTable = SqlData.Execute(var_insert)

It works perfectly most of the times, but if the user uses the apostrophe in his input (ie: I'm, he's, etc...) I get an SQL error.

To avoid that error I am extracting the apostrophes with
VALUE = replace(VALUE,"'",""), but that is not the solution I want, once the database will not be able to store a correct English spelling.

Can I get some help with this issue?