Re: SQL column formating

chuaby_at_hotmail.com writes:

>>
>> What version of Oracle and can you show us a sample of the data?
>
>
> I am using Oracle 8i. My data is stored as string.
>
> eg
>
> Start Date
> =========
> 01-Jan-2001
> Jan-2001
> 2001
>
>
> right justified. But currently, i am using lpad to push the data to the
> left to become
>
> Start Date
> =========
> 01-Jan-2001
> Jan-2001
> 2001
>
> so that it is easier to read.
>

Could you post the statement with lpad that you are using? It looks like you are padding to different widths. Something like

select lpad(start_date,11)

should do it.

Hope that helps,
Lothar

-- 
Lothar Armbrüster  | lothar.armbruester_at_t-online.de
Hauptstr. 26       |
65346 Eltville     |