AnsweredAssumed Answered

Problem with Finds

Question asked by rsagall_1 on Sep 22, 2009
Latest reply on Sep 22, 2009 by kapitaen_1


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)