Torna al Thread
DECLARE @Dummy AS TABLE(
Value decimal(10,5)
);
INSERT @Dummy VALUES(5817.60000), (890.00000);
SELECT STUFF(RIGHT('0000000000' + CAST(CAST(Value AS decimal(10,2)) AS varchar(11)), 10), 8, 1, '') AS StringValue
FROM @Dummy;
/* Output:
StringValue
------------
000581760
000089000
(2 row(s) affected)
*/