[thelist] Using Wildcards and Dates in SQL Server

Joe Lance JLance at humboldtbank.com
Tue Jun 17 11:43:59 CDT 2003

 where datediff(month, edate, getdate()) = 0


-----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

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!


* * Please support the community that supports you.  * *

Evolt.org conference in London, July 25-27 2003.  Register today at

For unsubscribe and other options, including the Tip Harvester 
and archives of thelist go to: http://lists.evolt.org 
Workers of the Web, evolt ! 

More information about the thelist mailing list