Hi,

> MsSql supports fields aliases. From memory, they can be used in WHERE
> clauses and the like, but since SQL by nature has no evaluation order, the
> following is invalid:

If i run this in MSSQL :

SELECT
ID,
RELATIEID AS ALIAS
FROM
Orders
WHERE
ALIAS = 3668

it fails with:
Invalid column name 'ALIAS'.

AFAIK it only support aliasses in the ORDER BY clause and NOT in the WHERE,
GROUP BY, HAVING clauses.

Running this on Oracle gives also a error:
ORA-00904: "ALIAS": invalid identifier

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird open source database (based on IB-OE) with many SQL-99 features :
http://www.firebirdsql.org
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/

Support list for Interbase and Firebird users :
firebird-support@yahoogroups.com

Nederlandse firebird nieuwsgroep :
news://80.126.130.81