>>< snip >
>>
>>>>What? Notable changes like SQL won't allow you to use the output column names in the ORDER BY clause in the first place? *g*>
>>
>>>Sure?
>>>
>>>Run this into MS SQL,it is ok:
>>>
>>>create TABLE #x1 ( firstname cHAR(10) )
>>>insert into #x1 values ( 'Dave' )
>>>insert into #x1 values ( 'Abe' )
>>>insert into #x1 values ( 'Albert' )
>>>select distinct substrING( firstname, 2, 5 ) as firstname
>>> from #x1
>>> order by firstname -- this is the output column Name
>>>
>>>DROP TABLE #X1
>>>
>>
>>
>>It is the group by that doesn't use output column names not the order by.
>
>This is correct because grouping a output column is a contradiction.
Right.
But if you set the EngineBehavior to 70, it will allow you to group by the output column.