Views - Quering multiple fields
Hi
I created extended user profiles and I'd like to query them.
Suppose a user lives in 2 states: STATE1: New York. STATE2: California, I can easily have 2 query boxes for STATE1 and STATE2, but I'd like to have ONE query box that will ask EITHER fields.
In SQL it will be something like: If STATE1="myValue" OR STATE2="myValue"
Is this possible with views?
Many thanks.

I managed to do:
If STATE1="myValue-1" OR STATE2="myValue-2"
but what I'd like to do is
If STATE1="myValue" OR STATE2="myValue"