Sign in
Microsoft.com
 
Microsoft
 
 
 

none
Case logic

 > 

    Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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 6, 2017 5:28 PM
    Thursday, April 6, 2017 1:53 PM
    |

Answers