Razzak and Steve: Thanks, that looks perfect.
I can't recall ever performing a "SET" to a function like that. Way cool. The WHERE clause and the pretest is the security. Much appreciated, Bruce -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Tuesday, September 24, 2013 2:39 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Mass UPDATEing a range of values In addition ... Using the example provided below, you may customize the UPDATE command with a WHERE Clause. At 05:24 PM 9/24/2013, Bruce A. Chitiea wrote: >All: > >A table 'pksEvent' holds several thousand entries of the following >values in TEXT column 'pkSpaceNO': > >1189A >1190A >... >1196A > >These are NOT the only values with the 'A' suffix; but they are the >ONLY values for which I need to change the 'A' to 'T'. > >I know how to do this using SRPL and UPDATE within a CURSOR, but can >this be done "one-shot" with an UPDATE command, no CURSOR? Bruce, Here's how ... UPDATE tablename SET colname = (SRPL(colname,'A','T',0)) That's all there is to it! Very Best R:egards, Razzak. www.rbase.com www.facebook.com/rbase -- 30+ years of continuous innovation! 15 Years of R:BASE Technologies, Inc. making R:BASE what it is today! --
