declare @a nvarchar(max)
set @a = '402844e42fa142a4012fb45fbfa40453,402844e42fa142a4012fb45fbfa40452'
select * from AuditRec where charindex(','+EmployeeID+',',','+@a+',')>0
set @a = '402844e42fa142a4012fb45fbfa40453,402844e42fa142a4012fb45fbfa40452'
select * from AuditRec where charindex(','+EmployeeID+',',','+@a+',')>0