STRING_AGG()

NULLs are eliminated:

SELECT STRING_AGG([Val], ',')
FROM (
	SELECT 'A' UNION ALL
	SELECT NULL UNION ALL
	SELECT 'C'
	) [a] ([Val])