Home Forums SQL Server 2008 T-SQL (SS2K8) Format Cast INT as Text RE: Format Cast INT as Text

  • October 7, 2013 at 11:26 am

    #1656454

    dogramone (10/3/2013)

    I just use a concatenate and a right.

    So select right('00' + cast(1 as varchar) ,2)

    Simple and makes sense. Thanks!