Greetings,

I am using FMP10adv on Windows Server 2003.

I have a field containing one or more of the following characters: SMFOICVPHX (but only one of each), so a particular field could contain S or SM or MS or FM or FMSO or any combination.

I am writing a script fed by checkboxes on a layout to search for all fields containing a character selected by the user.

If I manually go into Find Mode and enter *M* it will find all the correct records.

... but trying to script it as follows (after entering find mode):

Set Field[Table::Field;"*" & LeftValues($values;1)& "*"]

(where the LeftValues($values;1) pulls the M out of the checkboxes)

This does not get the right answer.

Can anyone clue me in?

LeftValues() leaves a trailing carriage return. Try the GetValue() function instead.

Fantastic, Thanks! It Worked.

(where would I find that level of detailed documentation about the various functions and their specifics?)

In the functions reference section of the help file. It's far from being perfect, but this particular oddity happens to be mentioned.