Something like the following might work (untested).

UPDATE dodom.table1
set column5 = SUBSTRING(column5, 1,4) CONCAT 'B' CONCAT
SUBSTRING(column5, 6,remaining_length)
where column2 = 'CP'

message: 7
date: Mon, 29 Oct 2007 16:38:13 -0700
from: "Dave Odom" <Dave.Odom@xxxxxxxxxxxx>
subject: Can UPDATE statement do something like this...

I'd like to use the UPDATE statement to update a specific
character in a character string of a column of a table.
Something like:

UPDATE dodom.table1 set SUBSTRING(column5, 5,1) = 'B'
where column2 = 'CP'

Of course the above bombs on the paren after SUBSTRING;
expects token like =

If not possible, I'll create a program using REXX and SQL.

Thanks in advance,

Dave O

This thread ...

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].