• Good to know!
    I would add  a where clause  to avoid empty string
    DECLARE @a VARCHAR(6) = 'ABCDEF'
    SELECT value FROM STRING_SPLIT(CAST(CAST(CAST(@A AS NVARCHAR) AS VARBINARY) AS VARCHAR), CHAR(0))
    WHERE value <>''