[thelist] Using Wildcards and Dates in SQL Server

[Gary McPherson]

> > SELECT * FROM curEvents WHERE DATEPART(month, eDate) = 6 AND 
> > DATEPART(year, eDate) = 2003
> 
> Well whaddya know. Thanks, Gary!
> 
> --ken

Glad I could help, but Jason made a further improvement which is the way
to go if you're trying to compare the eDate field to the current as
opposed to a fixed date.

All the best,

Gary