sqlserver里查询某个字段的值（使用，分隔）里是否有重复ID问题

Question

sqlserver 表 id (bigint) upIdList(nvarchar)行： 1 2，3，4 2 2，3，2

Answer 1

select id AS 编号,[dishesName] AS 菜名
from [dbo].[CB_Dishes]
where [dishesName] in (select [dishesName] from [dbo].[CB_Dishes] group by [dishesName] having count(1) >= 2)

Answer 2

自己写个函数呗，数据量不大的话，写函数，拆开判断吧，数据量大我也想问个答案