Re: Query Ques

[mwalter@xxxxxxxxxxxxxxx]

add a result field breaking the field out. You may have to add two. One
converting the numeric value to a string using DIGITS, Then use the SUBSTR
function. You must select the field to sort/break on it.

ex.

                              Define Result Fields
 Type definitions using field names or constants and operators, press
Enter.
   Operators:  +, -, *, /, SUBSTR, ||, DATE...
 Field       Expression                         Column Heading        Len
Dec
 MDATEA      digits(mdate)
 MONTH       substr(mdatea,4,2)

Bottom
 Field           Text                                                  Len
Dec
 ITNBR           Item number                                            15
 RECID           Record identifier                                       1
 INVFG           Inventory flag                                          2
0
 LOLEV           Low level code                                          2
0

More...
 F3=Exit          F5=Report         F9=Insert          F11=Display names
only
 F12=Cancel       F13=Layout        F20=Reorganize     F24=More keys


Thanks,

Mark

Mark D. Walter
Senior Programmer/Analyst
CCX, Inc.
mwalter@xxxxxxxxxx
http://www.ccxinc.com


                                                                                
                                                          
                      Mike Berman                                               
                                                          
                      <mikeba777@xxxxxxxxx        To:       Midrange Systems 
Technical Discussion <midrange-l@xxxxxxxxxxxx>               
                      >                           cc:                           
                                                          
                      Sent by:                    Subject:  Query Ques          
                                                          
                      midrange-l-bounces@m                                      
                                                          
                      idrange.com                                               
                                                          
                                                                                
                                                          
                                                                                
                                                          
                      07/21/2004 11:38 AM                                       
                                                          
                      Please respond to                                         
                                                          
                      Midrange Systems                                          
                                                          
                      Technical Discussion                                      
                                                          
                                                                                
                                                          
                                                                                
                                                          




HI Can I break on a portion of a field. I want to break the report by
month. The month is part of a yymmdd field. Can this be done in regular
Query/400?
Thank you,
Mike




---------------------------------
Do you Yahoo!?
Yahoo! Mail - You care about security. So do we.
--
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.