You can't compare to NULLs. How about this: How about NVL on the date setting a value deep into the past (1/1/80 seems reasonable) that will count as "never been viewed?"
--- Steven Duff <[EMAIL PROTECTED]> wrote: > I've been working on this for a couple of days now, and just can't get > this to function in one query. Running MSDE from Office XP, so that's > SQL Server 2000, Enterprise Manager from the demo, on Win 2K Pro. [big snip] __________________________________________________ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
