|
where currency in ('FRF', 'IEP', ...) =========================================================== R. Bruce Hoffman, Jr. -- IBM Certified Specialist - iSeries Administrator -- IBM Certified Specialist - RPG IV Developer "I want to be different, just like everybody else!" - Ceili Rain ----- Original Message ----- From: <steven.donnellan@simonjersey.com> To: <midrange-l@midrange.com> Sent: Thursday, December 13, 2001 12:05 PM Subject: Another week, another SQL request... > This is a multipart message in MIME format. > -- > [ Picked text/plain from multipart/alternative ] > On 1st January most national currencies in Europe will disappear to be > replaced with the Euro, and so we need to SQL our customer files... > Is it possible to do an SQL along the lines of; > UPDATE CUSTOMER FILE SET CURRENCY TO 'EUR' WHERE CURRENCY LIST 'FRF' 'IEP' > 'DEM'.... > you get the idea. > > Thanks in advance for your help, and a special thank you to the previous > poster who drew my attention to the SQL Cookbook download. (If you want a > copy, do a search for it on GOOGLE.COM and you'll be there in a jiffy!) > > Steven Donnellan > AS/400 Systems Manager > IBM Certified Specialist - AS/400 Professional Operator > Simon Jersey Ltd > > http://www.simonjersey.com > > ********************************************************************** > This email and any files transmitted with it are confidential and > intended solely for the use of the individual or entity to whom they > are addressed. If you have received this email in error please delete > it immediately and notify the sender, do not discuss or disclose the contents. > The views expressed in the e-mail are those of the author and not necessarily those of Simon Jersey Limited. > ********************************************************************** > -- > > > > _______________________________________________ > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list > To post a message email: MIDRANGE-L@midrange.com > To subscribe, unsubscribe, or change list options, > visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l > or email: MIDRANGE-L-request@midrange.com > Before posting, please take a moment to review the archives > at http://archive.midrange.com/midrange-l. >
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.