Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3574
  • Last Modified:

PL/SQL - Syntax for CASE when RuleID not equal to value 1 or not equal to value3

Hi again,
This is probably simple, but I can't get my statement to work with <> or not IN;

CASE WHEN (RuleID) not equal to 'Value1' or not equal to 'Value3' then 1.

Thanks and Happy Holidays,
Syhctl
0
syhctl
Asked:
syhctl
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
CASE WHEN RuleID NOT IN ( 'Value1' , 'Value3' ) then 1 ELSE NULL END
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now