select * from mydata where STR(numcol) like '%NaN%'
From Oracle 10g onwards, this is very simple as a special NaN value is made available for checking against:
select * from mydata where numcol is NaN
Monday, June 7, 2010
Checking for NaNs
In Sybase 12.5.4, checking for NaN is very simple - just convert the number to a string and check for the string!
From Oracle 10g onwards, this is very simple as a special NaN value is made available for checking against:
From Oracle 10g onwards, this is very simple as a special NaN value is made available for checking against:
Subscribe to:
Post Comments (Atom)
LinkWithin
1 comment:
Howdy! This is my first comment here so I just wanted to give a quick shout out and say I really enjoy reading through your articles. Can you recommend any other blogs/websites/forums that deal with the same topics? Many thanks! blog de seo
Post a Comment