RE: SubString SQL

[Eric DeLong <Eric.DeLong@xxxxxxxxxxxxxxxxx>]

     It depends somewhat on the data type in question. Obviously you are 
     working with dates, but are they defined in your database as 
     character, numeric, or date field?  
     
     Numeric field in YYYYMMDD format:=> SUBSTR(CHAR(numdatefield),1,4) 
     Date data type: ==================> YEAR(datetype)
     
     Those examples ought to get you going, assuming you are using 
     numeric or date types.
     
     hth,
     Eric


______________________________ Reply Separator
_________________________________
Subject: SubString SQL
Author:  "jacosta@idssinfo.com" <SMTP:jacosta@idssinfo.com> at EXCHANGE
Date:    12/8/00 8:11 AM


HI All,
     
Does anyone know how to substring a numeric field or a date field in SQL? I
am 
trying to use century and year to order by, on that same SQL statement.
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---