NULLs are eliminated: SELECT STRING_AGG([Val], ‘,’) FROM ( SELECT ‘A’ UNION ALL SELECT NULL UNION ALL SELECT ‘C’ ) [a] ([Val])