>SELECT ... > CASE WHEN ISNUMERIC(YourField+'e0') = 1 > THEN CAST(YourField as Numeric(xx, yy) > ELSE 0 END AS YourNumberField >Thanks, a condition case seems to be quite fine. In the mean time, we are looking into a resolution to fix the data also. So, additionnally, to place 0 as the value, based on some other fields, we might be able to calculate what was the value that was suppose to be there. If yes, a program will take care of that. If not, we'll then use that approach.