Case logic

• Question

• 

  

  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