RE: SQL instruction

THANK YOU TODD.

Pedro Salé Reis
MIS Assistent
Deptº Informática 
Hilti (PORTUGAL)
Tel. +351 22 956 8145
Fax. +351 22 953 76 96
E-mail reisped@hilti.com 


@@-  -----Mensagem original-----
@@-  De: Todd Sabella [mailto:Todd.Sabella@alltel.com]
@@-  Enviada: Quinta-feira, 31 de Maio de 2001 16:41
@@-  Para: RPG400-L@midrange.com
@@-  Assunto: Re: SQL instruction
@@-  
@@-  
@@-       
@@-       Use the AS clause to give the string exprression a 
@@-  more meaningful 
@@-       name...
@@-       
@@-       SELECT year||month||day AS Date FROM filename         
@@-                   
@@-        
@@-  ______________________________ Reply Separator 
@@-  _________________________________
@@-  Subject: Author:  RPG400-L@midrange.com at INTERNET
@@-  Date:    5/31/2001 8:36 AM
@@-  
@@-  Can anyone tell me how can i use in a SQL instruction the 
@@-  similar of the 
@@-  MAPFLD instruction of the opnqryf command..
@@-  i just want to concat 3 fields (year,month, day), in a 
@@-  single field DATE = 
@@-  year+month+day, i?ve just tried the concat operator 
@@-  year||month||day, but i 
@@-  would like to know if there is anything more similar to 
@@-  the opnqryf keyword
@@-       
@@-  Thanks!!
@@-       
@@-  Pedro Salé Reis
@@-  
@@-  +---
@@-  | 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
@@-  +---
@@-  
+---
| 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
+---