--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@u...> wrote:

>
> Hello Tony,
>
> Naah, you just have to tell it what datatype to use for - in this

case -

> the first column:
>
> select cast('Minimum' as varchar(9) ), ...
> UNION
> select cast('Maximum' as varchar(9) ), ...
>

Thanks for the suggestion Martijn but same error code returned.
Starnge that one UNION works OK but not two.

Rgds,