>> > Does anyone know how to compare only the Time portion of a Date
>> > field? If just run query "Select * from MyTable where Time1 <
> Time2"

> Actually, I forgot to mention that I did try that. I get error:
>
> "Client SQL dialect 1 does not support reference to TIME datatype".

...
where
cast('1.1.2000 ' || substring(Time1 from 12 for 14) as timestamp) <
cast('1.1.2000 ' || substring(Time2 from 12 for 14) as timestamp)

Ivan
http://www.volny.cz/iprenosil/interbase/