Now i have a field that is getting populated from 2 other fields based on which was in not null. We removed decimal point and 0 front filled it.

This is...

just realized that - i switched it over to money and am working with it

thanks

What happens if you have digits to right of decimal?

declare @value3 integer

@value3 = 197.81

SELECT RIGHT('000'+CAST(CAST(@value3 AS INT) AS VARCHAR(7)),7)

gives value 000197

any help on this would be appreciated.