Re: align columns

On 05-Feb-98 16:54:08 HTrieu wrote:

>how do i right justify the output in a column?

I don't know exactly, but I think there is a function called lpad. Try this:

select lpad(your_column,30) from your_table;

This should right-justify the output in a field of 30 characters.

Hope that helps,

Lothar

--
Lothar Armbrüster       | lothar.armbruester_at_rheingau.netsurf.de
Schulstr. 12            | lothar.armbruester_at_t-online.de
D-65375 Oestrich-Winkel |