Re: LIKE Clause with dates?

From: Mark G <mgumbs_at_nospam.hotmail.com>
Date: Tue, 22 Jun 1999 14:40:51 +0100
Message-ID: <376f901a.0@145.227.194.253>

The like clause is normally used against strings. You can try converting your date to a string (to_char(AsOfDate)) before your like comparison. It will work, however, if the date field is indexed, your query will not use the index since you invalidated it with your to_char function.

Mark

MADEIRA SALLY wrote in message <376F9100.3EC2CE4D_at_home.com>...
>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:40:51 CDT