WoodyGuthrie
MIS
How do I include only those rows where the 'InvoiceType' is not 3 except when the Vendor is 'ABC'.
When the Vendor is 'ABC' it doesn't matter what the InvoiceType is.
The value after 'Else' must not be a valid InvoiceType.
Is there a cleaner way to do this?
Thanks.
When the Vendor is 'ABC' it doesn't matter what the InvoiceType is.
The value after 'Else' must not be a valid InvoiceType.
Is there a cleaner way to do this?
Code:
Where
InvoiceType !=
case When vendorName != 'ABC'
Then 3
Else 99
EndThanks.