I konw the feelign./
ETA
DA Morgan <damorgan_at_exesolutions.com> wrote in message news:<3E6F6349.17BC194B_at_exesolutions.com>...
> Ethel Aardvark wrote:
>
> > Or LPAD!
> >
> > DA Morgan <damorgan_at_exesolutions.com> wrote in message news:<3E6E49C9.EF94122C_at_exesolutions.com>...
> > > Ubiquitous wrote:
> > >
> > > > I have a PL/SQL script which produces a columner report.
> > > > However, the first column is a NUMBER data type, so if I replace
> > > > the leading zeros with spaces the values get left-aligned.
> > > > Other than printing the value with leading zeros, is there a
> > > > way to make the values line up to the right?
> > >
> > > Look at the RPAD function. And pad with spaces
> > >
> > > Daniel Morgan
>
> Not "or"
>
> Thanks for the correction. My fingers were moving faster than my synapses.
>
> Daniel Morgan
Received on Tue Mar 25 2003 - 09:20:11 CST
