Hi,

> In Oracle we used to do
>
> Select <expression>
> from Dual
>
> e.g. Select F_dayofmonth('01-apr-2004')||' '||F_Dayofweek('01-apr-2004')
> from dual
>
> result will be "01 Mon"
>
> Is there any equivalent to this in Firebird SQL ?

Either use table "RDB$DATABASE", which is also a
one-row table, or simply do this:

CREATE TABLE DUAL ( DUMMY CHAR(1));
COMMIT;
INSERT INTO DUAL ('X');
COMMIT;

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com