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:234770 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
