>1. Returns the entire dataset as if no WHERE clause was included.
>2. ODBC-->SQL Server
Larry,
Run SQL Profiler and see what VFP sends to SQL Server.
Also COPY that SELECT and run it in QA or SSMS and see what happens.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.