• 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.