Q&A for enthusiasts and power users of the Android operating system
CREATE TABLE #table_name(randomDecimals decimal(10,2)); INSERT INTO #table_name VALUES (12162003.56), (5072004.66), (34.90), (5.50), (-333333.33); select REPLICATE('0', (15-LEN(REPLACE( REPLACE(randomDecimals,'-','') ,'.','')) )) + REPLACE(REPLACE(randomDecimals,'-',''),'.','') AS thing from #table_name