Problem with Finds
I have a database with a text field consisting of 16 characters - 2 alpha and 14 numbers - and is indexed. Most of the data in this field is AANNNNNNNNNNNNNN although some are NNAANNNNNNNNNNNN.
When I do a find for two alpha characters it works if the alpha characters are the first two characters, but not if the alpha characters are in the 3rd and 4th positions. If I search for four characters - NNAA then the find works.
Any suggestions on how to fix this problem?
(Running FM Pro Advanced 10.0.v3 on a Mac with 10.5.7)