> > Explictely cast the first column with e.g. a VARCHAR(5)
> > select cast('ident' as varchar(5)), count(*) from identtab
> > union...
> do not work.
>
> This was also my first thought. But CASTs only work within WHERE clauses. Don't they?

No.


Best Regards,
Thomas Steinmaurer

The IB LogManager Product Family
Logging/Auditing Suite for InterBase/Firebird
http://www.iblogmanager.com