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

Thanks, Jeff

You helped me break thru my blindness.

I was updating tagsm0 but checking tagsm0a.

I've just checked tagsm0. Plenty of "STEFAN' got appended.

Regards,

Stefan Fuma

n article <37ab3d6e.25400353_at_news>,
  jeff109_at_NOSPAM.netscape.net (Jeff Guttadauro) wrote:
> 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.
>
>

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