Hi John!
Are you sure that 'hour' contains full datetime string and not just hour number? I don't claim that I know this 'fact' better than you, just base on UT experience :).
>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.
Edward Pikman
Independent Consultant