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 |
|
vedjha
Posting Yak Master
228 Posts |
 Posted - 2008-10-06 : 01:24:44
|
| In sql we find ascii code like this,select ascii('A')select ascii('a')select ascii(' ')select ascii('$')Plz tell me how to find ascii code of "single invited comma" or (" ' ")I wrote the query as select ascii(' ' ')--------------------------------it gives errors as:===================================Msg 105, Level 15, State 1, Line 1Unclosed quotation mark after the character string ')'.Msg 102, Level 15, State 1, Line 1Incorrect syntax near ')'.Ved Prakash Jha |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-06 : 01:27:10
|
| [code]select ascii('''')[/code]EDIT:removed unwanted space in b/w |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-06 : 01:28:07
|
| Also refer this to understand how to handle single quotes in sqlhttp://sqlblogcasts.com/blogs/madhivanan/archive/2008/02/19/understanding-single-quotes.aspx |
|
|
|
vedjha
Posting Yak Master
228 Posts |
Posted - 2008-10-06 : 01:29:41
|
| thank uVed Prakash Jha |
|
|
|
|
|
|
plz help me to find out ascii Values