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!
--
