Home Forums SQL Server 2012 SQL Server 2012 - T-SQL TSQL no longer working in SQL2012 RE: TSQL no longer working in SQL2012

  • May 27, 2014 at 6:41 am

    #1716665

    Got it working -

    CONCAT (TEN.[tncy-sys-ref],CASE WHEN PER.[GENDER] = 'M' THEN '1'

    WHEN PER.[GENDER] = 'F' THEN '2'

    ELSE '0'END) AS 'ID'