-- =============================================-- 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)ASBEGIN  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 ENDGO