0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for researchers, developers, and users of Tor

CREATE TABLE #table_name(randomDecimals decimal(10,2));

INSERT INTO #table_name 
VALUES (12162003.56), (5072004.66), (34.90), (5.50), (333333.33);

select 
REPLACE(randomDecimals,'.','') as thing1,
LEN(REPLACE(randomDecimals,'.','')) as thing2,
15-LEN(REPLACE(randomDecimals,'.','')) as thing3,
REPLICATE('0', (15-LEN(REPLACE(randomDecimals,'.','')) )) 
            + REPLACE(randomDecimals,'.','') 
AS thing4
from #table_name

view current version

edited apr 19 18

created dec 4 15 anonymous