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

 

[Databaseguy]

You've gotta break apart your SQL statement using the & character.

"Select * FROM yourdata Where Yourfield = " & yourvariable & "rest of SQL statement"

Also, * is % in SQL statements with ASP pages.