Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: sql character function to fill a string

Re: sql character function to fill a string

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 27 Aug 2003 22:11:45 +0200
Message-ID: <vkq4ft24hd18fe@corp.supernews.com>

"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 address
Received on Wed Aug 27 2003 - 15:11:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US