Dear Svein, dear Thomas

thanks for your help. I'll use

select LocationId, LocationName from Locations
union
select -5, Cast('(new location)' as VarChar(64)) from Locations
order by 2;

which works fine. The second part of the union returns only one row even
when referencing table Locations.

Rolf Nussbaumer