Re: LIKE Clause with dates?

use TRUNC()

MADEIRA SALLY wrote:

> 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:50:38 CDT