SELECT * FROM RO WHERE cast(cast(Last_Date as char(10))+' '+Last_Time as datetime) as datetimecol > '2000-01-01 00:00:00'>I have a weird situation here. The client has a SQL Anywhere backend with a table having a Last_Date and Last_Time fields. Both are of type Date and Char. On the server, I have a timestamp. Basically, I need to get all the records from the client over the timestamp. This is quite complicated as they store the date and time in two different fields. How can I query that?