Hi Ed, Andersen:

SELECT * FROM table WHERE CTOT(hour) > CTOT(TIME())

This does it.


>>
>>I have a table that have a field Called HOUR and him data type is caracter.
>>
>>and i have to do a Select Sql wherer Hour > Time()
>>
>>how can i do this?
>>
>>thanks
>
>Something like this:
>nHour=HOUR(datetime())
>Select * From MyTable Where MyTable.Hour>nHour
>
>I guess you will also want to filter by date here, because without it the result does not make much sense.