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!