Maybe you can use the function SGET.
Select all from <table1> where (Sget(<columnname1>,20,1)) in (select (Sget(<columnname2>,20,1)) from <table2>) Tony From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: woensdag 22 december 2010 12:11 To: RBASE-L Mailing List Subject: [RBASE-L] - LIKE VS EQUALS I have two questions regarding using the word 'LIKE' in my code. 1) From the help it seems that LIKE is the same as EQUALS. Is that the case? 2) In the code, can you limit the number of characters you want to compare? What I want to do is compare two different columns (both text) in two different tables, but only 20 characters. James Belisle
