NAN - SQL qry to change?

[Ruslan Zasukhin]

On 30/10/07 5:01 AM, "Barry G. Sumpter" <barry at noodlebox.com.au> wrote:

> Hi all,
> 
> I remember seeing posts regarding nan.
> 
> In a v1.1 db I've got a double Indexed field that has a few records with the
> value of NAN
> In VS v3.5b6 in the data editor it shows as 1.00 but when selected for edit
> it shows 1.#QNAN
> I can't seem get a SQL select statement to select them to update the value
> to 0
> 
> Anyone know how to fix this via an SQL Query?
> 
> I can't clone as the db is 4 gig and takes 8 plus hours.

Only idea for now 

    SELECT * 
    FROM T 
    ORDER BY fldDouble

And check if this give you NANs at least in some group easy to find.


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