James,
The difference between LIKE and EQUALS is that EQUALS expects the two values being compared to be exactly the same and can work with non-text values, while LIKE permits the use of wildcards and only works on text. SET VAR v1 TEXT = 'abcde' SET VAR v2 TEXT = 'abc' IF v1 LIKE .v2 THEN . will evaluate false. SET VAR v2 TEXT = 'abc%' IF v1 LIKE .v2 THEN . will evaluate true. IF v1 = .v2 THEN . will evaluate false. Emmitt Dove Converting Systems Architect Evergreen Packaging, Inc. [email protected] (203) 214-5683 m (203) 643-8022 o (203) 643-8086 f [email protected] From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Wednesday, December 22, 2010 06: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
