As another follow up, thomas forgot the UNION ALL in his rewrite ;-)


SELECT
LocationId, LocationName
FROM
Locations
UNION ALL
SELECT
-5, Cast('(new location)' as VarChar(64))
FROM
RDB$DATABASE
ORDER BY
2



Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird links :
http://www.firebirdsql.com
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/


Nederlandse firebird nieuwsgroep :
news://80.126.130.81