Hi

I apologise if this is a stupid question but.....

We have a table with APLastDate (Date type) and APLastTime (Char(10) in
hh:nn:ss format) fields. I want to do an SQL which is, here Date and Time
are greater than these values. Is this possible? Can I cast a String in
that format to a Time and use it in a comparison?


Rob Martin
Software Engineer

phone 03 377 0495
fax 03 377 0496
web www.chreos.com
Wild Software Ltd