>I thought this would work as both sides of the equal sign would evaluate to a logical, but I get "Expression could not be evaluated" when comparing the two AT equations in the Debug window and an error when running the actual JOIN in code. I'm trying to find matches where a specific text string exist in the two fields in both cursors.
>
>
>JOIN MyCursor1 ON AT('TEXTSTRING',ALLTRIM(UPPER(MyCursor1.MyField)))>0 = AT('TEXTSTRING',ALLTRIM(UPPER(MyCursor2.MyField)))>0
>
If the ALLTRIM(UPPER() evaluates to 0, it will return an error. Could you match on a prtion of the string, say SUBSTR('TextString',3,4)?
Duty is ours, the results are God's - John Quincy Adams