Re: NOT IN (not working for me !)

From: Roya Mehrfar <roya_mehrfar_at_qmbridge.calstate.edu>
Date: 1996/07/12
Message-ID: <31E65532.1584_at_qmbridge.calstate.edu>#1/1

To make sure you cover the null cases change your where clause to:

NVL(REASON_CODE,'ZZZ') NOT IN ('398','498') Received on Fri Jul 12 1996 - 00:00:00 CEST

This message: [ Message body ]
Next message: Shawn Odekirk: "Help Forms 4.5 - MDI behavior"
Previous message: Rob Weeks: "NOT IN (not working for me !)"
In reply to: Rob Weeks: "NOT IN (not working for me !)"
Next in thread: Chuck Hamilton: "Re: NOT IN (not working for me !)"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message