NAN - SQL qry to change?

[Barry G. Sumpter]

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.

Ta