Thomas Miller wrote:

> select LocationId, LocationName from Locations
> union
> select CASE(-5 AS INTEGER), CAST('(new location)' AS VARCHAR(64)) from Locations
> order by 2;

select CAST(-5 AS INTEGER), CAST(' (new ... etc.

Just in *case* someone tries to copy/paste ;)

--
Milan Babuskov
http://fbexport.sourceforge.net