execute block
returns (s varchar(1024))
as
declare variable afrom varchar(1);
declare variable ato varchar(4);
begin
  s='AAAABBBBBCCCCCDDDD';
  afrom='A';
  ato='aaaa';
  s=replace(s,afrom,ato);
  suspend;
end