sqlsvr wrote:

> Thanks! One last question, in standard SQL...there is Row Constructors. Example: SELECT * FROM (('a','1'),('a','2'),('a','3')) AS tbl;
> How come this does not work in Firebird?

Firebird does not support such syntax. You can do:

select * from
(
select 'a' as col1, 1 as col2 from rdb$database union all
select 'a', 2 from rdb$database union all
select 'a', 3 from rdb$database
) tbl


--
Milan Babuskov

==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================