At 12:40 PM 2/04/2003 +0200, you wrote:

>I worked around this using a stored procedure. Still, I do wonder why
>
>SELECT AColumn
>FROM ATable
>WHERE Date1 BETWEEN Date2 - :OneInteger AND Date2 - :AnotherInteger
>
>insists on OneInteger being a TimeStamp when used in a normal TIB_Cursor or
>IB_SQL?

Bracketing?
What does this do ---

SELECT AColumn
FROM ATable
WHERE
(Date1 BETWEEN (Date2 - :OneInteger) AND (Date2 - :AnotherInteger))

Helen