RE: Need to modify this LIKE clause

ASTDTA.ICPRTMIA.IARCC9='ACS' AND
ASTDTA.OEINDLID.IDCOM#='001' AND
((ASTDTA.OEINDLID.IDPRT# LIKE 'ACS%') or (ASTDTA.OEINDLID.IDPRT# LIKE
'FR%')) AND
ASTDTA.ADRESSAD.ADSFX# =
SUBSTR(ASTDTA.OEINDLID.IDGRC#,9,3

This is pretty basic stuff. You may want to consider investing in a good
SQL book or two. There is also a wealth of information at the IBM
Information Center site.


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Hoteltravelfundotcom
Sent: Sunday, September 22, 2013 4:33 PM
To: Midrange Systems Technical Discussion
Subject: Need to modify this LIKE clause

I have a VIEW with these WHERE Conditions. I would like to add another type
on the 3 rd line here I want also those rows with like as "FR" is there a
way to sort of have such a group like that under the LIKE clause?


ASTDTA.ICPRTMIA.IARCC9='ACS' AND
ASTDTA.OEINDLID.IDCOM#='001' AND
ASTDTA.OEINDLID.IDPRT# LIKE 'ACS%' AND
ASTDTA.ADRESSAD.ADSFX# =
SUBSTR(ASTDTA.OEINDLID.IDGRC#,9,3
--
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.