Return Subset With All Remaining Records

Hello,

I need to pull records from single table such that I get a subset defined like this:

(
acctcode = 'xh364'
and
product = 'T&E'
)

And return all of the rest of the records:

(
acctcode = '%'
and
product = '%'
)

Can I do this within a WHERE clause, or will this require CASE / ELSE? There will be other specific acctcode/product rules that will be added later. I could do this with a UNION, but I need to avoid that if possible.


Thank you for your help!


cdun2