Yeah, good point - I knew I was close... -----Original Message----- From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org] On Behalf Of Ken Kogler Sent: Tuesday, June 17, 2003 1:35 PM To: thelist at lists.evolt.org Subject: RE: [thelist] Using Wildcards and Dates in SQL Server > Ummm... I imagine he'd want to use the date for that record, not the > current date: > > SELECT * FROM curEvents WHERE DATEPART(month, eDate) = 6 AND > DATEPART(year, eDate) = 2003 Well whaddya know. Thanks, Gary! --ken -- * * Please support the community that supports you. * * http://evolt.org/help_support_evolt/ Evolt.org conference in London, July 25-27 2003. Register today at http://evolt.org.uk For unsubscribe and other options, including the Tip Harvester and archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt !