Truncate string and count items from comma

func_TruncateWithCount.sql

CREATE OR ALTER FUNCTION dbo.func_TruncateWithCount
(
  @input nvarchar(max), @MaxLength int
)
RETURNS nvarchar(max)
AS
BEGIN

	IF (LEN(@input) <= @MaxLength)
		RETURN @input

	DECLARE @CountItems int;

	SET @CountItems = LEN(@input) - LEN(REPLACE(@input, ',', '')) + 1;

	RETURN SUBSTRING(@input, 1, @MaxLength) + '...('+CAST(@CountItems AS varchar)+')';
END