Re: CHECK A LIST OF LITERALS IN SQL

That would be the IN predicate
for example
SELECT CUSTID, NAME FROM CUSTOMER WHERE CUSTSTATE IN ('NY', 'NJ','PA')

OR
SELECT CUSTID, NAME FROM CUSTOMER WHERE CUSTSTATE IN (SELECT STATE FROM
WAREHOUSE)



Alan Shore

NBTY, Inc
(631) 244-2000 ext. 5019
AShore@xxxxxxxx
rpg400-l-bounces@xxxxxxxxxxxx wrote on 11/16/2006 03:46:40 PM:

I want to check for a list of literals in a variable,  just like you

would

with the LIST in query400...

how do you do that?





Thanks,


Jay Vaughn
iSeries Senior Programmer/Analyst
RateWatch
jayv@xxxxxxxxxxxxxx
251-633-8929
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing

list

To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.