Re: SQL - "contains" function?

["Raul A. Jager W." <raul@xxxxxxxxxx>]

For this to work maybe you have to concatenate a % at the begining and 
end of field5

POSITION finds if a string is contained in another.

Tom E Stieger wrote:

> This seems to work for me (v6r1):
>
> Select * from myfile where field100 not like field5
>
> -Tom Stieger
> IT Manager
> California Fine Wire
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Timothy Adair
> Sent: Thursday, January 26, 2012 2:21 PM
> To: midrange-l@xxxxxxxxxxxx
> Subject: SQL - "contains" function?
>
> I've searched the archives and Googled it, but so far, no soap.
>
> I'm using STRSQL to try to run a basic report, and I need some kind of
> "Contains" function.  In simplified form, here is what I'm trying to do.
>
> File has 2 fields:
> FIELD5    (5 char. alpha)
> FIELD100  (100 char. alpha)
>
>
> I want a report of all records where the string in FIELD5 is not
> contained anywhere within the string in FIELD100 (in the same record).
>
> Sounds simple, right?
>
> Apparently (best I can determine), there is no SQL function to use in
> the Where clause.  Or am I wrong?
>
> LIKE doesn't help.
>
> I know I can write a quick RPG program to do this, but if I (an
> SQL-newbie) can learn a new technique, it will make my day.
>
> Any thoughts?
>
> TIA for any and all responses.
>
>
> ~TA~ 
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
> unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
> moment to review the archives at http://archive.midrange.com/midrange-l.
>
>