ASP - how to remove single quote from user input text

Question

answer  = Request.Form("Text" & i) 

In a form a user inputs random text which is inserted into a database. Currently if the user puts in single quotes it creates an error. How do i remove just single quotes' from the users answer?

Answer 1

Use

answer.Replace("\'", "");

The above will replace the Single quote.