Home Forums SQL Server 7,2000 T-SQL Converting Integer to Text RE: Converting Integer to Text

  • May 13, 2008 at 5:46 am

    #814362

    Try This

    CASE WHEN [Extension]<80 THEN '0'+ CAST(Extension as VARCHAR(12)) ELSE CAST(Extension as VARCHAR(12)) END AS Extn