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

  • October 4, 2013 at 8:03 am

    #1655911

    dogramone (10/3/2013)

    I just use a concatenate and a right.

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

    I've used this method quite often. Simple enough.

    Kurt

    Kurt W. Zimmerman
    SR DBA
    Lefrak Organization
    New York, NY

    http://www.linkedin.com/in/kurtwzimmerman