查询字段值是多个逗号隔开的字段

1、

and ','+ R.FK_EXPERT_IDS + ',' like '%,'+ #{expertId} +',%'

 

2、

    and CHARINDEX(#{expertId},R.FK_EXPERT_IDS) > 0