> 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