PPAD inside UPDATE after column=RPAD(.....

Dear Friends,

.....here comes another "plea for help from a newby...

I am trying to append string "STEFAN" to column tagrun in table tagsm0:

The folowing UPDATE statement does the job:

   UPDATE sf.tagsm0a

                           SET
                                 tagrun =replace(tagrun,tagrun,rpad
(tagrun,length(tagrun) + 6,'STEFAN'))
                           WHERE
                        nameid = 'KERTD';

  but the simpler one below does not change the column: UPDATE sf.tagsm0

                   SET
                 tagrun = rpad(tagrun,length(tagrun) + 6,'STEFAN')
                  WHERE

                     nameid = 'KERTD';

Where am I misunderstanding the use of RPAD ?

Please help, please.... please ..... :-)

Regards,
Stefan Fuma

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Aug 06 1999 - 12:31:07 CDT