Return_Sorted_Comma_Separated_Strings.sql

-- Tested on SQL Server 2019
DECLARE @inputString NVARCHAR(100) = '1,3,2,4,2';

SELECT STUFF((
    SELECT ',' + CAST(value AS NVARCHAR(MAX))
    FROM STRING_SPLIT(@inputString, ',')
    ORDER BY CAST(value AS INT)
    FOR XML PATH('')
), 1, 1, '') AS SortedString;