I don't see the compatibility point in returning column names as either fully qualified or not. The effort to support both automatically by that piece of software which is parsing a DB engine's return values is quite small: it only has to accept additional '.' chars inside a column name. That code is still generic enough to work with all DBs.
I think the point is that many would prefer compatibility as much as possible.
The specific question was about the select statement, but in principal, many
of us would like to see some consistency across the various SQL
servers. It makes life a lot easier.
Regarding compatibility: there are more and harder to circumvent topics here. Think AUTO_INCREMENT, for example:
Absolutely true, but that's changing the subject. Has nothing to do with the original question.
Scott
Utilities for POPFile, the OpenSource Mail Classifier
http://www.geocities.com/Helphand1/popfile.htm
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
