sqlplus query problem

[Quoted] I'm have trouble with the sql query below... I don't seem to be able to remove the trailing whitespace in the first column.

spool E:/work/netcool_WORK_r26a_ab.csv

set feedback off
set serveroutput on size 100000
set termout off
set heading off
set echo off
set verify off
set pagesize 999
set trimspool on

SELECT  substr(av1.att_value,1,length(av1.att_value)),
        substr(av1.att_value,1,length(av1.att_value))
FROM    homs.attribute_defs ad1,
        homs.attribute_xref ax1, 
        homs.attribute_values av1,
                homs.attribute_defs ad2,
                homs.attribute_xref ax2, 
                homs.attribute_values av2
WHERE   ad1.name = '(WEB) HOSTNAME/LOGIN'
AND     ad1.unique_id = ax1.definition_id
AND     ax1.att_val_id = av1.unique_id
AND     ax.object_id = ax2.object_id
AND     ad2.name = 'INETNUM'
AND     ad2.unique_id = ax2.definition_id
AND     ax2.att_val_id = av2.unique_id

The first colunm ends up 255 characters wide. How can I prevent this?

Cheers,
Sean Received on Thu Mar 04 2004 - 13:51:40 CET