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

    Problem with Finds

    rsagall_1

      Title

      Problem with Finds

      Post

      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)

       

      Thanks,

       

      Rich