>>You can add
>>

>>WHERE ISNUMERIC(MyColumn) = 1
>>

>
>Thanks, so basically, this would filter out the records which are bad. Is that correct?
>

Yes

>Also, that syntax gives:
>
>"MyField" is not a recognized table hints option. If it is intended as a parameter to a table-valued function or to the CHANGETABLE function, ensure that your database compatibility mode is set to 90.

Hah?