I have a WHERE clause I need to add to a list of other WHERE clauses but this one below needs to evaluate to exclude based on two variables and this is pseudocode:
WHERE IF Customer is between 99202 and 99215 and State is NY then exclude
Should I be using "IFF" and what is the best syntax?:
AND NOT (IFF(Customer between 99202 and 99215) and State = 'NY')