>You can add
>
>WHERE ISNUMERIC(MyColumn) = 1
>
Thanks, so basically, this would filter out the records which are bad. Is that correct?
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.