Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: sql character function to fill a string
"Jon" <aaa_at_bbb.ccc> wrote in message news:biihvs$3ev$1_at_unbe.sarenet.es...
> Hi,
>
> Is there any function to fill with blanks a string?. The number of blanks
> depends on the value returned by another lenght function
>
> Thanks,
>
>
lpad and/or rpad will do the job.
Next time, could you *PLEASE* at least try to look up the SQL reference
manual? You would have found the answer much quicker
-- Sybrand Bakker Senior Oracle DBA to reply remove '-verwijderdit' from my e-mail addressReceived on Wed Aug 27 2003 - 15:11:45 CDT
![]() |
![]() |