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!
--
--- RBASE-L
=======================3D=======================3
D=
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
=======================3D=======================3
D=
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
=======================3D=======================3
D=
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
=======================3D=======================3
D=
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
=======================3D=======================3
D=
