Inserting Varchar To Decimal/Numeric

Hi,

Can we insert varchar values to Decimal(9,2)/numeric(9,2) fields?

I've a temp table with varchar values. I checked using isnumeric and all the values are numeric. But when I do the insert, it fails.

I was able to insert the following values:
000290165
000501075
000290165
000326314

But NOT the following:
010773474

All the values are 9 digits only.......
How can I convert this kind of numbers?

I need to convert all the 9 digit numbers to XXXXXXX.xx format.






(7digits.2 digits)

Thanks,
Siva.