Access, SQL, and apostrophes

[thatswimmer]

i have set up a javascript function to loop through form elements and replace (')'s with ('')'s, but are there any other special SQL characters that i need to be careful of when putting together queries from variables? Also, is there a way to do this in SQL instead of in javascript??

thanks

 

[Smarty]

it is possible to do the replace in asp with the following line of code
dim str
str = replace(str,"'","""&quot
I don't know of other special signs

Greetz,

Smarty