>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.
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope