Re: Conditional Select in SQL

I'm sorry Kent, maybe its just that its at the end of a long day, but what
you wrote just didn't make much sense.
My interpretation of your description is as follows:-

The table (file) contains a field called change date (CHGDTE for example)
You want to select rows when the entered date (DATEIN) is equal to the
change date (CHGDTE)
unless, the change date (CHGDTE) is 0, in which case you want to select
rows when the entered date (DATEIN) is equal to the change date (CHGDTE).

Like I said - end of a long day



Alan Shore

NBTY, Inc
(631) 244-2000 ext. 5019
AShore@xxxxxxxx

rpg400-l-bounces@xxxxxxxxxxxx wrote on 11/07/2006 04:02:18 PM:

Can someone tell me how I would do the following?  I want to create an
embedded SQL statement that will select rows when the change date in a

table

meets a certain date.  But, the issue is the change date may be zero.  If
the change date is zero, I want to select rows where the entered date

meets

a certain date.  I need all these selected in one group so I can sort

them

as a group.

Any help would be appreciated.
Kent Hohlen
Eagle Window & Door
PO Box 1072
2045 Kerper Blvd
Dubuque  IA  52004-1072

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