I have a Subjects table with a field Prerequisites, which contains data similar to the Subject IDs in the same table. So for example a subject4 may have the prerequisites subject2 and subject3. The contents of the Prerequisite field are delimited by ORs and ANDs, meaning if there are more than one prerequisites then the other may be optional or required. Anyway, I've a problem with selecting subjects with more than one prerequisite. How do I do this? If there's just one I could just do SELECT subjectID FROM Subjects WHERE Prerequisites = subjectID or something but I dont know how to include the delimiters.