Re: question about set statement

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.

greetz.

Jan Received on Thu Aug 23 2001 - 07:19:50 CDT