Home Forums SQL Server 2005 SQL Server 2005 General Discussion IF statement / Variables.. problems! RE: IF statement / Variables.. problems!

  • September 18, 2012 at 9:53 am

    #1539167

    perhaps like this?

    select case when @type1 = 'RFS' THEN

    case when @type2 = 'RFS' THEN

    case when @type3 = 'RFS' THEN

    case when @type4 = 'RFS' THEN 'ALL' ELSE @type4 END ELSE @type3 END ELSE @type2 END ELSE @type1 END