--- In firebird-support@yahoogroups.com, "Arno Brinkman"
<firebird@a...> wrote:
...

> > How can i do this?
>
> Just cast a literal value or NULL to the same datatype :
>
> SELECT
> SomeName AS Field1,
> SomeOtherStuff AS Field2
> FROM
> Table1
> UNION ALL
> SELECT
> OtherName,
> CAST(NULL AS VarChar(35))
> FROM
> Table2
>

Thx, that is what i need.

> Regards,
> Arno Brinkman
> ABVisie
>

Alexander