Hello all,

I would like to save the result of a query into a file, but I'm not
able to do it as i wish.

My query returns a varchar(2000) field.
When I try to save it using isql with:
- output file ;
- set heading off;
- select varchar2000 from mytable;
- output;

The generated file contains 2000 characters lines ... when I was
expecting only significant characters (without any blanks fidders).

Is there a way to generate a file with trimed lines ?

Thanks in advance
Regards

PAscal