try where datediff(month, edate, getdate()) = 0 hth, joe -----Original Message----- From: Ken Kogler [mailto:ken.kogler at curf.edu] Sent: Tuesday, June 17, 2003 9:25 AM To: thelist at lists.evolt.org Subject: [thelist] Using Wildcards and Dates in SQL Server Why doesn't this return anything? (SQL Server 2000, IIS5, Win2K) SELECT * FROM curEvents WHERE eDate LIKE '6/%/2003' I thought the % character worked as a wildcard -- am I missing something? There's got to be a million ways to get the current month's events out of this table. Anyone want to suggest a better one? Thanks in advance, folks! --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 !