SQLBill,

QUOTE: Not all the numbers are integers UNQUOTE.

I meant not all values are integer values (1,2,3 ...). There will be 1.15, 2.36 ...

If 1.15 as varchar cannot be converted to 1.15 decimal how can I get 1.15 into a numeric datatype without losing precision?

Thanks for your help!