sreddy (4/13/2009)
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]
Try this too.
SELECT [ID]
,[Title]
,[fname]
,[lastname]
,[Company]
,[Attention]
, IsNull( NullIf(Company, ''),fname+' '+ lastname) as displayname
FROM [Donors]
Regards
Vinay