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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 ASCII

Author  Topic 

khalidrana
Starting Member

5 Posts

Posted - 2008-01-13 : 01:37:16
Hello!
I can get ASCII value by just typing select/print ASCII(A)
in my Q.window
But, is there any way, if i just pass a valid digit and get back the character equivalent to the number?
Thanks for the help.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-01-13 : 01:51:30
CHAR function.



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

khalidrana
Starting Member

5 Posts

Posted - 2008-01-13 : 02:09:12
Thanks for your reply, Peter,
But can you please explain in a bit detail, Please write full syntax for finding character against the value of "79"
Thanks.
Go to Top of Page

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2008-01-13 : 02:12:52
use BOL for reference. http://msdn2.microsoft.com/en-us/library/aa258239.aspx



-ec
Go to Top of Page
   

- Advertisement -