Hi Steve,
>I have group records in a VFP6 table that begin with 'A1.', and if I put 'A1.' in the Where clause of my SQL-Select (set exact is off), I get no records returned. If I specify 'A1. Books on Horses' in the Where clause of the statement I get more records, but of course I don't get things like 'A1. Books on Elephants'. Help?
Sounds like you have SET ANSI ON. Set it to OFF and see if this makes a difference.
Christof
--
Christof