Hey there look i was just wondering if anyone can direct me or give me a list of all charcters that conflict with sql-->asp example if a variable holds the value '

thanks for your time.

http://www.centralearning.com/tbi/tbi_cp.jpg

Can you clarify the question? With the right character set encoding specified, a database and an ASP page can display any valid character.

Justin
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC

ok to elaborate for u when writing an sql query if my variable holds the value ' in it it errors and i have to filter the variable prior to inserting it into the dbase here is an example:

value="Grant's"
conn.execute("insert into [table] set firstname='" & value & "'")

Now so i was just wandering if there are any other characters that has an issue ie: ")(*&^%$#@!` i just want to document it so i know for future reference thanks.

http://www.centralearning.com/tbi/tbi_cp.jpg