Hi Folks,
I've run into an unusual situation. I have a data file which among others, has two fields: field one is a character field, length 50, and contains peoples names in the format '
, '; field two is a character field, length 6, and contains alphanumerics such as 'ABBR01' (the last two positions are numbers). If I set the index to fieldone+fieldtwo, I get a successful result with a seek command, but only if the seek term is the name only. For example, if the seek term is ', ' it works. If the seek term is ', '+ it doesn't work - I get a 'not found' message. I have checked and doublechecked the seek term and index terms to make sure they match.
If I reverse the sequence of the index terms, that is, I make the index and seek terms fieldtwo+fieldone, it works.
Has anyone encountered this or can anyone explain it?
Thanks,
Alan Zaben
cancer_survivor@yahoo.com