Syntax needed for combining & updating char fields 1

[mars19301]

There are over 700 id_recs (primarily schools) where the "Saint" is erroneously in the title field not in the fullname field where it belongs. I need the syntax to add St. in front of the fullname when I update the appropriate records.
OLD = Catherine High School
NEED= St. Catherine High School

See script below:

Thank you in advance
Jim


select
id_rec.title,
id_rec.fullname,
title_table.txt
from id_rec,
outer title_table
where id_rec.title = title_table.title
and id_rec.title = "ST "
into temp bba with no log;

begin work;
update id_rec

set fullname = (("St. &quot,fullname) this line syntax doesn't work and is where I need the syntax

where id_rec.id in(select id from bba)

 

[vpshriyan]

Hi,

Use concatenation symbol, that is, || to this value join operation as below:

begin ;
update id_rec
set fullname = ( select "St. "||fullname
from bba where id_rec.id=bba.id );
rollback;

Regards,
Shriyan
"It takes a lot of patients to be a successful doctor."

 

[mars19301]

Many thanks, Shriyan!!! Worked perfectly.

Jim