quote:

---

Originally posted by JeffS23

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO





ALTER FUNCTION FormatName
(@pPrefix VARCHAR(10),
@pFirst VARCHAR(30),
@pMiddle VARCHAR(30),
@pLast VARCHAR(30),
@pSuffix VARCHAR(20)
)
RETURNS VARCHAR(256)
AS
BEGIN
DECLARE @pf VARCHAR(10), @fn VARCHAR(30), @mi VARCHAR(30), @ln VARCHAR(30), @sf VARCHAR(20)
SET @pf = ISNULL(@pPrefix, '')
SET @fn = ISNULL(@pFirst, '')
SET @mi = ISNULL(@pMiddle, '')
SET @ln = ISNULL(@pLast, '')
SET @sf = ISNULL(@pSuffix, '')

IF LEN(@pf) < 1
SET @pf = NULL
IF LEN(@fn) < 1
SET @fn = NULL
IF LEN(@mi) < 1
SET @mi = NULL
IF LEN(@ln) < 1
SET @ln = NULL
IF LEN(@sf) < 1
SET @sf = NULL

RETURN RTRIM
(
LTRIM
(
ISNULL(@ln,'')
+ CASE WHEN @sf IS NOT NULL THEN ' ' + @sf ELSE '' END + ', '
+ CASE WHEN @pf IS NOT NULL THEN @pf + ' ' ELSE '' END
+ CASE WHEN @fn IS NOT NULL THEN @fn + ' ' ELSE '' END
+ LTRIM( ISNULL(@mi,'') )
)
)
END

















GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

---