SQL Server function to truncate a string and add an ellipsis

f_truncateWithEllipsis.sql

CREATE FUNCTION [dbo].[f_truncateWithEllipsis]
(
	@value VARCHAR(8000),
	@maxLength INT
)
RETURNS VARCHAR(8000)
AS
BEGIN
	SET @value = LTRIM(RTRIM(@value));

	RETURN	CASE WHEN LEN(@value) > @maxLength
					THEN LEFT(@value, @maxLength - 1) + '…'
				 ELSE @value
			END
END