>> 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??

Eihter set the interval to some big values so that heading is written only once
using command line parameter

-page 100000

Or switch it off completely using command

SET HEADING OFF;

Ivan
http://www.volny.cz/iprenosil/interbase/