AnsweredAssumed Answered

Problem with Finds

Question asked by rsagall_1 on Sep 22, 2009
Latest reply on Sep 22, 2009 by kapitaen_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

 

Outcomes