有问题吗?
--> 测试数据:#tb
IF OBJECT_ID('TEMPDB.DBO.#tb') IS NOT NULL DROP TABLE #tb
GO
CREATE TABLE #tb([ID] INT,[字段A] VARCHAR(5))
INSERT #tb
SELECT 1,'a,b,c' UNION ALL
SELECT 2,'c,b'
--------------开始查询--------------------------
SELECT LEN(字段A)-LEN(REPLACE(字段A,',',''))+1,id FROM #tb
----------------结果----------------------------
/*
(无列名) id
3 1
2 2
*/
DECLARE @i TABLE(id INT ,col VARCHAR(10))
INSERT INTO @i(id,col)
SELECT 1,'a,b,c'
UNION
SELECT 2,'c,b'
SELECT id,(LEN(col) - LEN(REPLACE(col,',','')))+1 AS 数量 FROM @i
/*
id 数量
1 3
2 2*/