>If this is raw sql then this will work as well. Sql Anywhere will automatically convert a properly formatted string to datetime. In fact if the time part is 00:00 then you can leave that off as well.
>
>
>SELECT * FROM RO
> WHERE cast(cast(Last_Date as char(10))+' '+Last_Time as datetime) as datetimecol > '2000-01-01 00:00:00'
>
This is much simpler.
Thanks