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

  • May 13, 2008 at 5:19 am

    #814345

    hi

    Try this

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