you need something on the left side of the comparison, like this:

"SELECT Top 10* FROM Customer where customer.date > '2008-12-22'"

to see the date format, run a select * from customer

brad

On Wed, Dec 24, 2008 at 11:53 PM, Robert <rob_jurado@...> wrote:
> Does anyone know the syntax for date fields on the where clause?
>
> I am trying to query this:
>
> "SELECT Top 10* FROM Customer where > '2008-12-22'"
>
> but it is giving me the following error:
> ERROR [S0000] [QODBCPOS] Invalid operand for operator: >
>
> Thank you.
>
>



--
Brad Waddell, Managing Director
FLEXquarters.com Limited
Skype: bradwww