Ah, honestly do not know if it returns any or not in Oracle since I never or rarely have used it. I just know it works because I tried it earlier.
On 3/8/06, Jim Wright <[EMAIL PROTECTED]> wrote: > > I think he is saying that it won't work the same as IS NULL. It > doesn't error out, but it also doesn't return any NULL records. At > least that is the way it is in SQL Server...is Oracle the same? > > On 3/8/06, Aaron Rouse <[EMAIL PROTECTED]> wrote: > > Works in Oracle, at least it does in 9i, do not know for certain on the > > other versions. > > > > On 3/8/06, Bryan Stevenson <[EMAIL PROTECTED]> wrote: > > > > > > NULL should NOT work in an IN clause. > > > > > > Bryan Stevenson B.Comm. > > > VP & Director of E-Commerce Development > > > Electric Edge Systems Group Inc. > > > phone: 250.480.0642 > > > fax: 250.480.1264 > > > cell: 250.920.8830 > > > e-mail: [EMAIL PROTECTED] > > > web: www.electricedgesystems.com > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234774 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
