Luis Cazares - Friday, December 29, 2017 8:56 AM

Jack Corbett - Friday, December 29, 2017 8:47 AM

This is an even simpler option:

WITH VTE AS
  (
   SELECT
    *
   FROM
    (
      VALUES (3),
        (25.75),
        (12),
        (125.8),
        (1000),
        (1857.5)
    ) V (I)
  )
SELECT VTE.I, FORMAT(I*10, '0000') AS LeadingZeros FROM VTE;

I usually avoid FORMAT due to its fame of being slow.