>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
I have just done this with lots of different combinations and it worked every time. The only time it did not work is when I had two equals signs together.