Hi, you have to create a UDF function for this and use like this

SELECT ... WHERE IsNan(myfield)>0

or UPDATE WHERE IsNan(myfield)>0

Slavek

Ing. Slavomir Skopalik
Jednatel spolecnosti
Elekt Labs s.r.o.
Chaloupky 158
783 72 Velky Tynec
Czech Republic
--------------------------------------------
Mobil: +420 724 207 851
icq:199 118 333
e-mail:skopalik@...
http://www.elektlabs.cz <http://www.elektlabs.cz/>






Thankyou for your post.

Do you know how to fix the database for taking out these NAN values?

I did gFix several times, gBak and restore but it is not working for this.

Is there any way for instantiating the records that contain the NAN value?

I have tried to make a SELECT... WHERE myfield = NAN but doesn't work.

HDuqueC







[Non-text portions of this message have been removed]