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

  • October 3, 2013 at 11:40 pm

    #1655744

    I just use a concatenate and a right.

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