>BROWSE FOR ALLTRIM(UPPER(m.lo1)) $ UPPER(person.first) works
>
>BROWSE FOR UPPER(person.first) $ ALLTRIM(UPPER(m.lo1)) does NOT work
>
>What's going on? The BROW was for a test since the actual SQL does not work.
>
>Chuck

The way the $ 'Contained in' sign works is you are asking to give me all the records that have this string contained in this field

BROWSE FOR 'ThisString' $ ThisField

or

BROWSE FOR records where ThisString is Contained in ThisField

So the order does matter. As

BROWSE FOR ThisField $ 'ThisString' would not work.