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.
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,