jasonwyz98
Programmer
urgent
How to determine wheather a value is NaN (infinity) using SQL statements?
thanks
jason
How to determine wheather a value is NaN (infinity) using SQL statements?
thanks
jason
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to determine wheather a value is NaN (infinity) using SQL statment
- Thread starter jasonwyz98
- Start date
- Status
mrdenny
Programmer
- May 27, 2002
- 11,595
NaN is not infinity. NaN means Non a Number (I'm assuming that you got this from javascript?)
What platform are you using?
Denny
MCSA (2003) / MCDBA (SQL 2000)
--Anything is possible. All it takes is a little research. (Me)
![[noevil]](/data/assets/smilies/noevil.gif "[noevil] [noevil]")
(Not quite so old any more.)
What platform are you using?
Denny
MCSA (2003) / MCDBA (SQL 2000)
--Anything is possible. All it takes is a little research. (Me)
(Not quite so old any more.)
- Thread starter
- #3
jasonwyz98
Programmer
thanks for replying,
the DB is Sybase, I'm trying to write some SQL to determine whether a value is NaN, currently when i select a NaN value i get 0.0 back which I know isn't right. Please provide the correct SQL statements? thanks
the DB is Sybase, I'm trying to write some SQL to determine whether a value is NaN, currently when i select a NaN value i get 0.0 back which I know isn't right. Please provide the correct SQL statements? thanks
- Status
Similar threads
- Locked
- Question