At 10:55 AM 02/08/2002, you wrote:

>I'm using CONTAINING to search any field in my table. On a TIMESTAMP
>field I have determined how to search on almost everything except for
>a date which includes the year.
>
>For example if my field contains: 01/02/2003 14:05:06

A better example would be the SQL syntax you tried.

Try:
where MyDate CONTAINING :MonthDay
and MyDate CONTAINING :TheYear

where params: MonthDay := '01-02' and TheYear := '2003'

Strange that it doesn't work in one string though. Is this a feature or a bug?

Scott.