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!
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

1 comment:

Unknown said...

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

LinkWithin

Related Posts Plugin for WordPress, Blogger...