Searching For A Value In A Column Row Using The "In" Clause

Is there anyway to search each row within one column for a value ? The "IN" clause appears not to work for multiple values in a row.





SELECT Table_Payee_List.CategoryIDs, Table_Payee_List.PayeeSelectBox INTO GOTIT

FROM Table_Payee_List

WHERE (((Table_Payee_List.CategoryIDs) In ("25")));





Data (two columns with 5 rows) are represented below:



Payee CategoryIDs

Column Column



John Doe 21, 27, 32, 34, 44 - Row 1

Jane Doe 20, 25, 28, 42, 44 - Row 3

Paul Doe 19, 25, 28, 42, 44 - Row 3

James Doe 56, 29, 31, 62, 54 - Row 4

Amy Doe 24, 25, 29, 42, 74 - Row 5

Searching For A Value In A Column Row Using The "In" Clause