-- =============================================
-- Author:          Clive Chinery
-- Create date: 08Nov2008
-- Description:    Trim long strings to prescribed length
-- =============================================
CREATE FUNCTION dbo.ufnTrimLength 
(
  @Input  NVARCHAR(2000),
  @Length INT 
)
RETURNS NVARCHAR(2000)
AS
BEGIN
  DECLARE @Return  NVARCHAR(2000)
  DECLARE @DLength INT
  IF @Length <    4 SET @Length = 4
  IF @Length > 2000 SET @Length = 2000
  SET @DLength = LEN(@Input)
  IF (@DLength >= @Length)
    SET @Return = SUBSTRING(@Input, 1, @Length - 3) + ‘...‘
  ELSE
    SET @Return = @Input
    RETURN @Return 
END
GO