>Hello All
>
>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