How can I use the where clause of a select query to identify records where a numeric field is NaN?
SELECT * FROM myTable WHERE myNumericField = 'nan';
myField is defined as Float (or in other cases could be Double)
...and that didn't generate any errors, but also didn't return any results. If I leave off the WHERE clause completely, I can easily see the text 'nan' in myNumericField, yet when I use the WHERE clause it claims that zero records are found which meet that criteria.
If I leave off the quotes (...WHERE myNumericField = nan) or use the IS operator (...WHERE myNumericField IS Nan), I get errors.
Thanks for any assistance you can provide,