Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Swede
Yak Posting Veteran
74 Posts |
 Posted - 2002-01-09 : 07:06:12
|
| Since in SQL and ASP you have to replace " into something else, example |||, so that it doesn't mess up your INSERT and UPDATE, and then back again with a Chr(34).Does anyone know where I can find all of the Chr()'s?=====================================Why not try and do the impossible?Edited by - Swede on 01/09/2002 07:07:16 |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-01-09 : 07:15:10
|
| HiIf you delimit your SQL text with apostrophes ( ' ) then having " in there shouldn't matter. If you want apostrophes, double them ('')For your main question though, try a Google search on "Ascii Character Chart"http://www.google.com/search?q=ascii+character+chartDamian |
 |
|
|
Swede
Yak Posting Veteran
74 Posts |
Posted - 2002-01-09 : 07:18:55
|
Thanks  I am using the Replace command in an admin tool I created recently so that people cannot really enter any kind of data which could give them an error message... And to make it easy for them...Thanks for the tip though. Hehe Should have known they were just plain Ascii letters...=====================================Why not try and do the impossible? |
|
|
|
|
|
|
SQL Characters