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,''));

DECLARE @Numbertable table
(
	ID INT PRIMARY KEY
	
)


INSERT INTO @Numbertable
select TOP 1000 ROW_NUMBER() OVER(order by si.object_id)
from sys.objects si,sys.objects s

declare @mylist nvarchar(100)
set @mylist = 'A,B, C, D , 1, 2,345, EFG, H,'

select COUNT(string)
from
(
select 
	NULLIF(SUBSTRING(@mylist,id,CHARINDEX(',',@mylist+',',id)-ID),'') AS string
from @Numbertable
where id <= LEN(@mylist) and SUBSTRING(','+@mylist,ID,1) = ','
)d