>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
This should work if voucher_data is Date field:
>SELECT claim_number FROM DEDUCTIONS WHERE voucher_date={04/09/97}
Edward Pikman
Independent Consultant