Ron - thanks for the link. I wasn't aware of that.

However, the ISNumeric query is working as I intend. I do get an overflow when trying to update those records where IS_Numeric = 0. Basically, i want to do an update either based on IS_Numeric=0 or Value= "-1.#IND". Either would work for me.

But I can't execute a straight query of the table. I need to CONVERT the float column to NVARCHAR to see the offending data.

Thanks again.

IS_Numeric Value

0-1.#IND

0-1.#IND

0-1.#IND

0-1.#IND

0-1.#IND

0-1.#IND

0-1.#IND

18.57704

18.60668

18.61399

18.62084

18.62934