Perhaps you can use something like this:

range1 = dtot({^2001-09-09})
range2 = dtot({^2001-09-09}+1)
... where d_startdate between range1 and range2

The basic idea is to select all records between midnight 2001-09-09 and midnight of the next day.

>Hi,
>when I try to select with a numeric or character comparison in the where-part, it functions OK.
>But how can I use a time/date comparison in the where-part?
>I use this query and put it in the sourceproperty of an ADO command object:
>SELECT N_ID,C_NAME,C_PLATE,D_STARTDATE, .... FROM database WHERE D_STARTDATE = CTOD('09-09-2001')
>I understand that the CTOD command doesn't exist where (in ADO) the query runs, but I really need to select by date...
>
>TIA ET