The problem with the original query is that it was trying to convert to a NUMERIC(5,4), which will hold a maximum value of 9.9999. The value "35" has two digits left of the decimal, but NUMERIC(5,4) allows only one. Therefore, an overflow resulted. The query that worked (above post) changed the CONVERT to use NUMERIC(3,0), resulting in sufficient space to hold a two-digit number. I suggest you use a NUMERIC value large enough to hold all the expected values. For example, if you want to hold 10,000 as listed in the original post, you will need a NUMERIC(5,0), NUMERIC(6,1), or something where the first digit of the NUMERIC definition minus the second digit is 5 or greater (5-0=5; 6-1=5, etc).