--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...> wrote:

>
> At 03:37 PM 1/08/2006, you wrote:
> >Hi guys,
> >
> >I'm trying to write an extraction shell script that will be crontabbed
> >in a unix box. At certain days, it will extract out some data and save
> >them as a file via firebird's iSql.
> >Here's my problem.
> >Because the files extracted will be input for another program, i'l
> >need to format the search results in such that the columns are
> >seperated by a delimiter.
> >
> >Ex:
> >
> > Currently, querying in iSql will give sth like
> >
> >USERNAME USERID
> >============================== ==========
> >UAT 02 uat02
> >UAT 03 uat03
> >
> >Say i choose to use a # as my column delimeter, Is there a way i can
> >set iSql to return it as the following instead?
> >
> >#UAT 02#uat02#
> >#UAT 03#uat03#
> >
> >Thanks in advanced guys!
>
> select
> '#' || username || '#' || userid || '#' as usernameandid
> from atable
>
> ./heLen
>

hmm....this seems to work ok. But after every 20 lines, it would print
the feldname:

Concatenation
======================

Is there any way to turn this off??
thanks for the idea again