Re: Alias Column Names

> I need to sort by a field that does not have a standard field name.
>
> There is a view that has been written as such.
> SELECT firstname as "First Name", lastname as "Last Name" FROM
> tablename;
>
> I want to select from that view and order by the last name field. Is it
> possible and if so how can I do it?

select * from viewname order by "Last Name";

or

select * from viewname order by 2;

Stephan Schlecht

--
Software 7 GmbH           
Regensburg          
http://www.software7.de