Tony, I was working on that very function when I received your reply.
I believe I have what I want. I just have to figure how many characters to use. Thanks for the help. James Belisle ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of A.G. IJntema Sent: Wednesday, December 22, 2010 5:44 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: LIKE VS EQUALS 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
