Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL JOIN using AT()
Message
From
03/06/2004 05:51:43
 
 
To
02/06/2004 17:10:00
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00909403
Message ID:
00909491
Views:
10
This message has been marked as the solution to the initial question of the thread.

.... 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
Previous
Reply
Map
View

Click here to load this message in the networking platform