Hi All. Thanks for your help.

I worked out another way to get the results.

CREATE PROCEDURE [dbo].[MyProc]

(

@First=null,

@Second int=null,

@Third int=null,

)

AS

select e.*, e.empfname +

case when e.empmname is null then '...