LIKE Clause with dates?

I have a procedure with paramaters of

Procedure GetParticipations(AsOfDate IN DATE)

The date is usually the last date of the month.

I would like to create a LIKe Clause so that my WHERE statement specifies all records WHERE DatePart LIKE '3'..%..'99'

The AsOfDate being '3/31/1999'

How would that be accomplished!

Thanks in Advance
Sally Received on Tue Jun 22 1999 - 08:31:23 CDT