searching multiple fields for one value

The problem is, I'm querying a table for a specific value. This value can be in 6 different fields in the table. They hold different Sanction Responses in them(strings).

SancResp1, SancResp2, SancResp3, SancResp4, SancResp5, SancResp6

They are all varchars[50]. And example would be "Alcohol Education". Instead of just pulling rows and checking 1-6 in a loop one by one, I was wondering if I can just write a more specific query to check these six fields. I'm getting the search value from a form from the previous page($Sanction).

while I should just read Ch. 6 of Matt's String handling book, I forgot it at home :rolleyes:. I know I don't write very good queries so any ideas are appreciated.