Ok, I am sure this is easy to do, I

[zzfive03]

Ok, I am sure this is easy to do, I just dont know what code should look like. I have an ASP page that takes in a string from a textarea box and puts it in a SQL table. Problem is it gives errors if the user enters a ' or a " into the box. How can I write a function that will remove or correct this string before it is saved into the database?

 

[JohnYingling]

Try
strW = Replace(strIn,"'","''&quot

http://WWW.VBCompare.Com

 

[zzfive03]

Got it, worked great, thank you!!!!