Hey,

find the following soln...

SELECT [ID]

,[Title]

,[fname]

,[lastname]

,[Company]

,[Attention]

, case when (Company is not null or len(Company) <> 0)

then [Company]

else fname + ' ' + lastname

end as displayName

FROM [Donors]