Re: SQL find a string in multiple fields

On 12-Oct-2016 11:47 -0500, Gerald Magnuson wrote:

I have a "search string" field to scan over multiple fields...

currently we are doing this with RPG example:

if s1xcnt = *blanks or
%scan(%trim(s1xcnt):%xlate(lw:up:mnujob)) > 0 or
%scan(%trim(s1xcnt):%xlate(lw:up:mnuonm)) > 0) ;

I am attempting to do this in a where clause, but not getting it
right


where UPPER(mnujob) like('%.......%)
or UPPER(mnuonm) like(%......%)

I have tried doing various %trim commands,
I have tried doing this as both a Prepared SQL statement, and inline...
I tried doing this with OmniFind, but that was overly complex with
building multiple index objects...

First, dispense with the UPPER nonsense, and just use a shared-weight sort sequence. Second, create an actual example with DDL and sample data [or if no TABLE, then give variable declaratives], plus how [from where and using what variables; the same program?] the request is to be invoked [dynamic or embedded]. The actual DDL [or host variable declarations] is important; per note of possibly wanting TRIM, what are the actual column definitions or host variable definitions is often quite important to make the LIKE predicate function as desired.