|
Thanks all, using digits did exactly what I wanted. Mark A McCarty "Steve Brazzell" <steve@brazzell.com> on 08/30/2000 10:59:23 AM Please respond to RPG400-L@midrange.com To: RPG400-L@midrange.com cc: (bcc: Mark McCarty/HQ/NEXNET) Subject RE: sql help : Fax to: Mark, I believe you want DIGITS(mm) CONCAT DIGITS(dd) CONCAT DIGITS(yy) This works for me, at least. hth Steve Brazzell Innovatum, Inc. -----Original Message----- From: owner-rpg400-l@midrange.com [mailto:owner-rpg400-l@midrange.com]On Behalf Of Mark_McCarty@nexnet.navy.mil Sent: Wednesday, August 30, 2000 4:10 PM To: RPG400-L@midrange.com Subject: sql help I am attempting to string together a series of numeric fields(MMDDYY) into a view, is this possible? The three fields I'm attempting to string are 2,0 numeric. I have attempted the following: 1> char(mm) || char(dd) || char(yy) which provides spaces between the numerals. 2> strip (char(mm)) || strip (char(dd)) || strip (char(yy)) which cuts off the 0's. anybody have a solution?? I'm fairly new to sql and am hoping to be able to create and embed a series of views to an rpg program for data gathering and the produce a report from results. Any assistance would be greatly appreciated... TIA Mark A McCarty ********************************************************************** This email and any files transmitted with it are intended solely for the use of the individual or agency to whom they are addressed. If you have received this email in error please notify the Navy Exchange Service Command e-mail administrator. This footnote also confirms that this email message has been scanned for the presence of computer viruses. messaging_support_team@nexnet.navy.mil ********************************************************************** +--- | 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 +--- ********************************************************************** This email and any files transmitted with it are intended solely for the use of the individual or agency to whom they are addressed. If you have received this email in error please notify the Navy Exchange Service Command e-mail administrator. This footnote also confirms that this email message has been scanned for the presence of computer viruses. messaging_support_team@nexnet.navy.mil ********************************************************************** +--- | 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 +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.