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