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