Maybe ... UPDATE 'pksEvent' SET pkSpaceNO = (SRPL(...)) WHERE pksEvent BETWEEN '1189A' AND '1196A'
Key is to test your WHERE-clause with a SELECT BEFORE running your UPDATE ... and have a backup. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Bruce A. Chitiea Sent: September 24, 2013 4:25 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Mass UPDATEing a range of values 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? 'Preciate any pointers, Bruce
