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
 General SQL Server Forums
 New to SQL Server Programming
 How to display degree in SQL server?

Author  Topic 

mageshks
Yak Posting Veteran

59 Posts

Posted - 2008-09-26 : 04:41:47
Hi ,

How to display the degree in the SQL server?
For example 9°

thanks in advance

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-09-26 : 04:44:17
Try CHAR(176)
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-09-26 : 04:56:11
See more characters and numbers


select number, CHAR(number) as chars from master..spt_values
where type='p' and number <256 order by number

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-09-26 : 04:58:59
quote:
Originally posted by madhivanan

See more characters and numbers


select number, CHAR(number) as chars from master..spt_values
where type='p' and number <256 order by number

Madhivanan

Failing to plan is Planning to fail


Nice illustration
Go to Top of Page
   

- Advertisement -