Handling Quotation marks for SQL Insert

[SmileyFace]

Hey Guys. Really need your help with this one.

I am inserting data into an SQL server table from my asp page but need a function to handle the single quotation marks. I basically need to read the string being inserted into the table field and replace any single quotation marks (') with double quotes (&quot before inserting else I will get an error. PLEASE HELP me with this!! Would really appreciate it if someone could help me with the script.

Thanks a lot!

 

[onpnt]

thread333-600736
thread333-287702
thread333-437474

_____________________________________________________________________
_{Where have all my friends gone to????}

http://www.onpntwebdesigns.com