where in multiple columns

[andrew niesen]

Hi,

I am attempting to search multiple columns for the same foriegn key.

I have the following columns in my catalog_images table:
nID,
strFileName,
nCategoryA,
nCategoryB,
nCategoryC,
nCategoryD,
nCategoryE

and I want to select strFileName from catalog_images where ANY of the following matches occur:
nCategoryA="1",
nCategoryB="1",
nCategoryC="1",
nCategoryD="1",
nCategoryE="1"

I can't figure out my query string. Any suggestions?

Thanks!

Andrew