At 11:21 AM 9/11/2003 +0000, you wrote:

>Hi
>
>I am about to write a report module for a customer in delphi5 using an
>TIB_Query and FastReport
>
>The generic SQL will be as below , with the search date criteria set by
>the user.
>
>select id from pins
>where Cast(status_changed as Date) >= Cast('5-Nov-2003' as Date) and
>Cast(status_changed as Date) <= Cast('15-Nov-2003' as Date)
>
>
>Obviously I can build this SQL statement up in my program and set the SQL
>property without any problems.
>
>I don't think however this is the best way to do it in Ibobjects.

It's not the best way to do it in database!! Why are you casting
status_changed?

>Can anyone recommend a better way ?

I hope so. Please provide more info about these data types.

Helen