Sorry, I think it should be IS NULL. NULL does not equate to anything so = will not work.
Example: select * from suppliers where supplier_name IS NULL; On 8/9/07, daniel kessler wrote: > > > status <> 'Removed' OR Status = NULL > > This also didn't work. I received no error, but no more items showed than > before. > > daniel > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285830 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
