Razzak & Jason, I thought there was a way to do it with SRPL and this worked great.
Thank you both, Paul -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Tuesday, June 23, 2015 3:10 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: SQL Question At 02:43 PM 6/23/2015, Paul Buckley wrote: >I am using the latest eXtreme 9.5 (64) and I've got a question for the >SQL gurus. Here's some sample data: > >A table has 2 columns, customerID and CustName CustomerID       >CustName >1 ABC 123 >2 ABC 234 >3 ABC 345 >4 DEF 123 >5 DEF 234 >6 GHI 123 >7 GHI 234 > >Is there a SQL Update command (or other command) that will change the >‘ABC’ portion of the column CustName to ‘XYZ’, the results >would be: > >CustomerID       CustName >1 XYZ 123 >2 XYZ 234 >3 XYZ 345 >4 DEF 123 >5 DEF 234 >6 GHI 123 >7 GHI 234 > >I know I can do it with a snippet of code and a declare cursor but just >wandering if there is a slick SQL command. > >TIA, >Paul Buckley Paul, I don't know about the SQL gurus, but you can certainly use the SRPL function of R:BASE to accomplish your goal. At the R> prompt: HELP SRPL should provide you with the exact syntax and examples. Very Best R:egards, Razzak. www.rbase.com www.rbaseX.com www.facebook.com/rbase -- 32 years of continuous innovation! 17 Years of R:BASE Technologies, Inc. making R:BASE what it is today! --
