.... 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
this find matches where a specific text string exist or not exists in the two fields in both cursors
( XOR logical ).
use this for found only where text string exist in the two fields in both cursors
JOIN MyCursor1 ON ATC('TEXTSTRING',MyCursor1.MyField)>0 AND ATC('TEXTSTRING',MyCursor2.MyField)>0