:) indeed he would need to be pretty darn brave to parse a SQL statement using XSLT.
This is a standard SQL-feature, that should work in any SQL-compliant database (at least I know it works in MSSQL and DB2 also). But I guess that the problem is that Johann lets the user enter SQL directly, loosing control of whats submitted to the DB. (which seems like a huge security risk, but I guess that this is adressed elsewhere in the application...)
Johann - if you are brave ;) - you could use XSLT to parse the submitted SQL, and then extend the SELECT-clause with aliases?
Less braveness though required with antlr, i'm sure there are few SQL92 grammars around that suit his needs.
Alternatively there are various opensource java relational databases around, they must have already done the hard work.
Jorg
Askild
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
