Subject AW: [firebird-support] more then two unions
Author Klement Guenther - Munich-MR
Thomas wrote

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

SQL can sometimes be very tricky.


PS: Thanks to Daniel who find out the problem.