I have a field that contains a numeric list (1,2,4,12,13,15)
I want to pull all records that contain the item '2'. However doing a search for :: like * & '2' & * :: returns a record where the field contains 12 and not 2.
If I change it to read :: like *& ',2,' &* :: I get only items containing '2' so no items containing only 2 or 2,3 or 1,2
any ideas on how I can do this in a query? I am not using vbscript at all - just a simple query.
WHERE member_List Like "*" & [which list] & "*"