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 |
ganeshkumar08
Posting Yak Master
187 Posts |
Posted - 2008-06-21 : 03:40:58
|
Hello,Is there any built in function to find out the sign of a value.For Ex: -225.89 Sign is - 566.987 Sign is +ThanksGanesh KumarSolutions are easy. Understanding the problem, now, that's the hard part |
|
PeterNeo
Constraint Violating Yak Guru
357 Posts |
Posted - 2008-06-21 : 04:24:39
|
read about SIGN() in BOL |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-06-21 : 14:06:56
|
orselect col,case when col<0 then -1 when col=0 then 0 else 1 end as sign from your_tableMadhivananFailing to plan is Planning to fail |
|
|
|
|
|