DECLARE @Ids NVARCHAR(255)
SET @Ids ='as,sdf,dsaf,sdfsd'
DECLARE @ID varchar(32), @Pos int , @commcount bigint
SET @Ids = LTRIM(RTRIM(@Ids))+ ','
SET @Pos = CHARINDEX(',', @Ids, 1)
SET @commcount=0
IF REPLACE(@Ids, ',', '') <> ''
BEGIN
WHILE @Pos > 0
BEGIN
SET @ID = LTRIM(RTRIM(LEFT(@Ids, @Pos - 1)))
IF @ID <> ''
BEGIN
SET @commcount = @commcount + 1
END
SET @Ids = RIGHT(@Ids, LEN(@Ids) - @Pos)
SET @Pos = CHARINDEX(',', @Ids, 1)
END
END
select (@commcount-1)