Re: SQL - pad a string to fill up to a certain length?

dean wrote:
> Is there a command that will take a string (vcarchar2), and (if its
> less that N characters long, PAD it will spaces until it is N
> characters long? Like the reverse of TRIM.
>
> Thanks!
>
> Dean

LPAD and RPAD will do it.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)