RE: Fuzzy string matching?

["John Taylor" <lists@xxxxxxxxxxxxxxxxxxxx>]

Jim, 

> embedded sql works great for this in RPGLE.
> There have been many posts/examples on this in midrange-rpg
> the select statement
> SELECT ORDNUM  FROM ORDFILE WHERE ORDNAM LIKE '%THOMPSON%'
> will give you a result set of any order with THOMPSON 
> anywhere within field ORDNAM. jim

I don't think that's what James' was asking for. For a "fuzzy" search,
one can use the SOUNDEX function within your SQL:

SELECT ORDNUM  FROM ORDFILE WHERE SOUNDEX(ORDNAM) = SOUNDEX('THOMPSON')


Regards,

John Taylor