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

Hi, Stefan.

        Although I'm not quite sure why you would want to do it this way, the second update worked fine for me. Maybe it's just that the table name is not correct...? Should the second one use sf.tagsm0a also? Anyways, if you just want to do concatenation and not really padding, why don't you just do the following?

UPDATE sf.tagsm0a
SET tagrun = tagrun||'STEFAN'
WHERE nameid = 'KERTD';

Hope this helps,
-Jeff Guttadauro

On Fri, 06 Aug 1999 17:31:07 GMT, fuma_at_voicenet.com wrote:

>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 - 14:59:21 CDT