Can't find a text field in a record

[George Hsu]

I'd a text field in all records in FM4. I only can find the record by specifying

the text up to a certain character in the string. When I specify it beyond that character,

I can't find that record. But other records with same text field can be found.

The text field is defined as "text with index if necessary". The text string

is "Boc-LPYEGSLLLKLLRAPVEEV-HMP Resin". I can find the record only by

specifying up to the 1st "V" i.e. *RAPV* (* wild card cahracter). I can't find the record if I specify

up to "E", i.e. *RAPVE*, but I can find all other records with the same fields

in the records. I can't figure it out why. Is there anybody can help me on

this ? Thanx

[Fitch]

FileMaker versions prior to 7 only index the first 20 characters of each word. I think this is your problem. Maybe you could break that field by a calculation into smaller chunks and search on the chunks.

FYI FileMaker 7 indexes 100 characters per line (which could be a single word).