3 Replies Latest reply on Sep 22, 2009 3:07 AM by kapitaen_1

    Problem with Finds



      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)