Hello all, I need help on solving this problem. I have a table "Table A" with ID and Items Fields. ID is unique. Items Filed contains Part numbers with ';' dilimited. ID | Items 1 | AFF-12D; ACC-15S; 2 | ACC-15S; 2 | KXX-1129; How can I select rows with ACC-155. How can i do it? Thanks in advance.