Is there anything wrong with the following? It executes without
error, but the NOTES field is unchanged afterwards.
NOTES & DELIVERY_CHARGE are VARCHAR(256) & VARCHAR(40 respectively.

SET TERM !! ;
create procedure move_dlvry_chg_to_notes
as
DECLARE VARIABLE SuplrNo integer;
declare variable ss varchar(300);
begin
for select SUPLRNO, (delivery_charge || ' ' || notes) from
suppliers into :SuplrNo, :ss
do
begin
update suppliers set notes = :ss where SUPLRNO = :SuplrNo;
end
end !!
SET TERM ; !!

Thanks,
Steve