NAN - SQL qry to change?

[Barry G. Sumpter]

Yeah, try doing that to 1 to 3 million records.

Can't select a NAN:
SELECT fldDouble 
FROM T where fldDouble = 'Nan' or '-nan' or '1.#uNaN'



-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net] On Behalf Of Ruslan Zasukhin
Sent: Wednesday, 31 October 2007 7:28 AM
To: valentina at lists.macserve.net
Subject: Re: NAN - SQL qry to change?

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]


_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina