Thanks that is really cool and just what I needed. Is there a way of
stopping the OUT statement after it has served its use ? and can one run 2
SELECT's that however amend to the existing file rather than replace it ?

At 04:50 PM 2/23/2004, you wrote:

>Uwe Oeder wrote:
>
> > Can I let a SELECT statement run from ISQL , so that the output gets
> stored
> > in a file in a comma delimited way ?
> >
> > SELECT *
> > FROM ItemsProcessed
> > WHERE ItemName LIKE '%A' ;
> > put in file me.txt ???
>
>run isql
>SQL> out me.txt;
>SQL> select col1, ',', col2, ',', ... etc;
>SQL> exit;
>
>HTH
>
>--
>Milan Babuskov
>http://fbexport.sourceforge.net
>
>
>
>
>
>
>Yahoo! Groups Links
>
>
>
>