Search 2 tblColumns with One Criteria

[deadhead7]

Can you search 2 different columns in a table(columns are exactly the same)using only 1 criteria. For example 2 columns contain zipcodes, I want to enter on a form in a text box one zipcode and have it then search both columns to return those records.

Can this be done??

 

[tviman]

This will show records from both columns:

select zipcode1,zipcode2 from <table> where zipcode1 = <zipcode variable> or zipcode2 = <zipcode variable>

This will show only records where the zipcode exists in both columns:

select zipcode1,zipcode2 from <table> where zipcode1 = <zipcode variable> and zipcode2 = <zipcode variable>


There's always a better way. The fun is trying to find it!