I have a
Customer
FirstName
LastName
CompanyName
CompanyName
CompanyName
CompanyName
NULL
FirstName
LastName
select ID, (FirstName + ' ' + LastName) as EntityName from Customer
select ID, (CompanyName) as EntityName from Customer
select
EntityName
CompanyName
Select ID
,EntityName = case when Isnull(CompanyName,'') <>'' then CompanyName else FirstName + ' ' + LastName end
From Customer