Fuzzy Matching In RPG
December 3, 2014 Ted Holt
Note: The code accompanying this article is available for download here. SQL allows you to use wildcard characters with the LIKE operator to search a column for a pattern. As they say in the GEICO commercials, “Everybody knows that.” Well, did you know you can do the same thing in RPG programs? If you’re not familiar with LIKE, read about it here. You can use the LIKE operator to find data with inexact matches. For instance, find all customers whose names contain “ACME”. select * from cust where name like '%ACME%' ID NAME ===== ========================================== 19883 ACME |