none
Case logic

    Question

  • Hi 

    I have a select statement like:

                            select ...

    ,case when role in ('Coverage Attorney', 'Defense Attorney') then FirstName
    else ''
    end FirstName
    ,case when role in ('Coverage Attorney', 'Defense Attorney') then LastName
    else ''
    end LastName
    ,case when role in ( 'Coverage Law Firm',  'Defense Law Firm') then LawFirm
    else ''
    end LawFirm

                          From ...


    now I want to add if LastName = 'Not Available' then Lawfirm. How can I add this to the logic?

    Thank you!

         
    • Moved by litdev Thursday, April 06, 2017 5:28 PM
    Thursday, April 06, 2017 1:53 PM

Answers