[thelist] Using Wildcards and Dates in SQL Server

Ken Kogler ken.kogler at curf.edu
Tue Jun 17 12:35:05 CDT 2003


> 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



More information about the thelist mailing list