CREATE PROCEDURE dbo.format_recommendation STRING_AGG Exceeded Limit Error

[lostsole]

Fails on this line:
WHEN 1
THEN CONCAT ('CLUSTERED INDEX (', STRING_AGG(c.Name, ', ') WITHIN GROUP (ORDER BY ic.key_ordinal ASC), ')')

Had to change it to get results back:
WHEN 1
THEN CONCAT ('CLUSTERED INDEX (', STRING_AGG(Convert(VARCHAR(MAX),c.Name), ', ') WITHIN GROUP (ORDER BY ic.key_ordinal ASC), ')')