Checking NAN or -NAN In Access 2007

Question

We are in the process of migrating Access 2007 to SQL 2005.

We have a table with about 200 columns of float fields. Some of the fields have values of positive infinity or negative infinity ( 1.#INF or -1.#INF when viewed in Access ).

Is there a way to clean this day or identify this data so we can report back to the owners the bad records in the database that we cleaned on the way to SQL.

If have tried a query in ACCESS or attempting:

= NAN = 'NAN' ='1#INF' =1#INF =float.NAN