• This is simpler...

    declare @mylist nvarchar(100);

    set @mylist = 'A,B, C, D , 1, 2,345, EFG, H,';

    declare @delim varchar(2)=',';

    select LEN(@mylist) - LEN(replace(@mylist,@delim,''));