SQL charindex 通过id字符串获取数据

传入id集字符串，如：0001,0002,0003,0005 查询获取所需数据

NOTICENOS:传入的id集

select a.*, b.NOTICE_NO, d.NAME as CARD_STATUS_NAME from MES_PP_PROC_CARD a
left join MES_PP_NOTICE b on a.NOTICE_ID = b.NOTICE_ID
join CM_OT_ENUM_TYPE c on c.ENUM_TYPE_CD = 'CARD_STATUS_EK'
join CM_OT_ENUM_TYPE d on d.PARENT_ID = c.ENUM_TYPE_ID and a.CARD_STATUS_EK = d.ENUM_KEY 
where charindex(',' + a.CARD_NO + ',', ',NOTICENOS,') > 0