The following statement works fine in Microsoft Query (accessing a SQL Server database):

SELECT claim_number FROM DEDUCTIONS WHERE voucher_date=04/09/97

It produces an Operator/Operand type mismatch error in VFP 5.0.

The voucher_date field is type DateTime on the SQL Server.

Any ideas?

Jeff