This

WHERE (PATINDEX(('%,' + SecurityGroupReferenceID + ',%'), (','+@Roles+',')) > 0)

almost works for me.  Now I have narrowed down the problem to the individual roles I am passing.  These are actual...

That is exactly right.  I was just trying to make it too complicated with joins, etc. 

Thank you very much dan

I want to retrieve a distinct Film_prod_guide.recno.  I do not want multiple instances of the same recno.  It can be possible to have and ACTIVE=1 for either the Guide record...