Re: SQL select question

Try this
 C+        (REYR4*10000 + REMONT*100 + REDAY)  >= :SDATE   and
...
Fernando



                    Lori Crane
                    <lcrane@emedco.co        Para:   rpg400-l@midrange.com
                    m>                       cc:
                    Enviado por:             Asunto:      SQL select question
                    rpg400-l-admin@mi
                    drange.com


                    10/04/2002 12:36
                    Por favor,
                    responda a
                    rpg400-l





Can anyone help me out?  I am trying to select data from a Revenue file
based on the date range the user keys in.  It can be many ranges for dates.
The file has a YYYY MM DD fields(REYR4, REMONT, REDAY).  How can I combine
all date fields in Revenue file and make on 8 0 S date field for comparing
what the user keys in?  I tryed a data structure unsuccessfully.

 **-*-*-*-*
 C/exec sql
 C+ Declare C1 cursor for
 C+ Select *
 C+ from REVENUE
 C+ WHERE REMKRE = :MKMOD2 and
 C+        (REYR4 + REMONT + REDAY)  >= :SDATE   and

 C+        (REYR4 + REMONT + REDAY)  <= :EDATE
 C+ order by REYR4, REMONT, REDAY, REMKRE
 C/end-exec
 **-*-*-*-*
_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.