RE: Can UPDATE statement do something like this...

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