Where Clause with Case statement needed in my query?
Posted on 2009-05-06
I have to fields - may contain combinations of "AWP" or "ACQ" values - the instructions I were given are:
"If both values are AWP, filter should INCLUDE any row where AWP amount > 0. If both values are ACQ, filter should INCLUDE any row where ACQ amount > 0. If one values is AWP and the other is ACQ, filter should INCLUDE any row where AWP amount and ACQ amount > 0. "
Question is - how to I need to construct my WHERE clause to accomodate? I assume I need some kind of case statement around all of this