So Jeff, how do you solve this version of the problem?

declare @i decimal(10,5)

Set @i = 1078.734

PRINT REPLACE(@i,'.','')

--What's needed? 107873400 or 1078734

Set @i = 0.034

PRINT REPLACE(@i,'.','')

--003400 OR 34?

Set @i = 0.0304

PRINT REPLACE(@i,'.','')

--003040 OR 304?