Limiting Length of Values Selected from SQL*Plus ??

This should be an easy one, but I cannot get it.

Here is a sample of my problem:

Table: T_FOO
Has one column: DESCRIPTION VARCHAR2(255) Has two rows: one row with the value 'test' in the DESCRIPTION column

               one row with the value 'testtesttest'

If I run this query:
SELECT DESCRIPTION, 'ZZZ'
FROM T_FOO; I get this:
DESCRIPTION

test          (251 blank spaces)                   ZZZ
testtesttest  (243 blank spaces)                   ZZZ

What do I need to put on my select to get this: DESCRIPTION

I have tried using rtrimming and substringing for the length of the value but I have not gotten anywhere.

Any help would be greatly appreciated.

Thanks,
Alan Slay

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Oct 27 2000 - 23:15:51 CEST