NAN - SQL qry to change?

[Ruslan Zasukhin]

On 30/10/07 10:13 PM, "Barry G. Sumpter" <BarrySum at BigPond.Net.AU> wrote:

> There is NO way to select a NaN value using a select statement.

SELECT fldDouble 
FROM T 
 
I.e. SELECT all records of table do not selects NAN ???
I believe it does.

And note, that above cursor with ONE field,
    give you VERY FAST iterate that field,
    because other fields of table even will not be loaded from disk.


> You have to iterate thru every record from a development language.
> 
> And check the all the numeric values for NAN.
> Anywhere in the field as some return -Nan, Nan, 1.#nan, etc.
> 
> Then update the Nan records.
> 
> Someone may be able to write a stored procedure to do the same.

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]