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.
midrange.com
