I have two files related by a Location field.

I am not able to get to the records that have more than 20 characters in the location field if there are other records that have the same first 20 characters in the Location field,

For example:

Details in the record with location "GigabitEthernetBBone" is always shown for records "GigabitEthernetBBone_london", "GigabitEthernetBBone_paris" or "GigabitEthernetBBone_tokyo".

Does anyone share the same exprience. Any work arounds?

Thanks.

Only the first 20 characters of *words* are indexed. From memory the first 120 characters of the *string* are indexed where the string is composed of multiple words.

Words are separated by spaces. Put some spaces in those strings instead of underscores. Easiest way -- and most reversible -- is to create a calc field and use the Substitute[] function to replace underscore with space characters.