Re: question about set statement

From: jAnO! <j.j.groot_at_kpn.com>
Date: 23 Aug 2001 12:34:35 GMT
Message-ID: <01c12bcf$f7382100$532b15ac@TONTW0108082044>

jAnO! <j.j.groot_at_kpn.com> schreef in artikel <01c12bcf$1038ff40$532b15ac_at_TONTW0108082044>...
>
>
> jAnO! <j.j.groot_at_kpn.com> schreef in artikel
> <01c12bcd$e7da7bb0$532b15ac_at_TONTW0108082044>...
> >
> >
> > Markus Stuhlpfarrer <mstuhlpfarrer_at_hollomey.com> schreef in artikel
> > <3B84ED5D.2EE74496_at_hollomey.com>...
> > > syntax error
> > > lpad has 3 parameters for this:
> > > select lpad(2,3,'0') from dual
> > > this gives: '002'
> > >
> > > lpad(2,0) gives back an empty string (0 length)
> > > lpad(2,3) adds spaces (' 2')
> > > lpad(2,3,'0') adds zeroes ('002')
> > >
> >
> > thanks, but this only gives another representation of the data in a
> select
> > statement, i want to set the data.
> >
>
> Sorry bout that, it works, i had to remove the trailng spaces, thanks
> Xavier...
>
> goeten,
>
> JAn

oops too soon, doesnt't work yet..
so i'm open for other suggestions...

>
Received on Thu Aug 23 2001 - 07:34:35 CDT