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: LKBrwn_DBA <member30625_at_dbforums.com>
Date: Wed, 27 Aug 2003 12:09:42 -0400
Message-ID: <3291665.1062000582@dbforums.com>

Try:

RPAD(string, str_len,'<pad char>')

and

LPAD(string, str_len,'<pad char>')

Note: replace str_len with your length function.

;)

--
Posted via http://dbforums.com
Received on Wed Aug 27 2003 - 11:09:42 CDT

Original text of this message

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