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?

My SQL is

Select cTitle from Books where cCat1 = 'A1.' into cursor testreslt