NAN - SQL qry to change?

[Barry G. Sumpter]

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

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.

hth 

-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net] On Behalf Of Barry G. Sumpter
Sent: Tuesday, 30 October 2007 1:01 PM
To: 'Valentina Developers'
Subject: NAN - SQL qry to change?

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



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