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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-12 : 09:09:29
|
| seb writes "What characters can and can't i use in an SQL string?Are there any articles on how to process forms with SQL in mind?I can't use ' characters in a text field cause this will mess up the SQL update.Any advise on this subject appreciated." |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2002-04-12 : 09:09:29
|
| I should think you can use any characters you want in a string including apostraphes (http://www.sqlteam.com/item.asp?ItemID=293). |
 |
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2002-04-12 : 10:38:16
|
| look up quotename() in BOL.setBasedIsTheTruepath<O> |
|
|
|
|
|
|
Bad characters in SQL syntax