Do I need to add all states to an IN?

I have a resume form that picks consultants by state (such as an html guru in California, or an SAP expert in Alabama). But what if I want to pick from ANY state? When I put in criteria, the SQL comes back like so... SELECT SQL_CALC_FOUND_ROWS * FROM resume INNER JOIN candidate WHERE

Re: Do I need to add all states to an IN?

At 11:25 -0400 10/11/04, Eve Atley wrote: I have a resume form that picks consultants by state (such as an html guru in California, or an SAP expert in Alabama). But what if I want to pick from ANY state? When I put in criteria, the SQL comes back like so... SELECT SQL_CALC_FOUND_ROWS * FROM