I have a query and I'm trying to see if one of the SQL variables is LIKE one of the items in a list. At the end of the query I have
AND tblPerson_RTIDetail.personUnit IN (#PreserveSingleQuotes(session.userRoleUnits)#)
This appears to be doing only a direct match. Can I use "LIKE" in place of "IN" and, if so, how would I place the %?
Thanks a lot!