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?

Probably because that syntax is an extension specific to SQLServer.
Other systems (e.g. PostgreSQL) have similar constructs with slightly
different syntax.


Cheers,

Ann

P.S. I don't believe that's your last question - feel free to keep
asking.