Home Forums SQL Server 2005 T-SQL (SS2K5) Remove decimal places and force leading zeros RE: Remove decimal places and force leading zeros

  • April 7, 2011 at 7:32 am

    #1308512

    SELECT RIGHT('000'+CAST(CAST(MyField AS INT) AS VARCHAR(4)),4) should do the trick