sqlsvr wrote:

> In SQL Server, you can do this in the Query Analazyer (which executes a query and displays the results):
>
> SELECT 'a' AS column1;

SELECT 'a' AS column1 FROM RDB$DATABASE;

>
> You can also do this:
> DECLARE @somevariable INT;
> SET @somevariable = 1;
> SELECT @somevariable;
>
> Can someone translate this to Firebird SQL?

set term ^ ;
execute block returning ( somevariable integer ) as
begin
somevariable = 1;
suspend;
end^

Regards,

--
Milan Babuskov

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