I've done this in a UDF

Code:
CREATE FUNCTION dbo.GetFullName_F (@LastName as varchar(35),@FirstName as varchar(20),@MiddleName as varchar(20),@Suffix as varchar(10),@Opt as int)
RETURNS varchar(100) AS  
BEGIN
	Declare @WN varchar(100)

	Set @WN=IsNull(@LastName,'')+', '+IsNull(@FirstName,'')
		+Case When IsNull(@MiddleName,'')<>'' Then ' '+@MiddleName Else '' End
		+Case When IsNull(@Suffix,'')<>'' Then ', '+@Suffix Else '' End

	RETURN @WN
END