This is incorrect. SQL Server does support ORDER BY on a column alias. It also does support ordering by function.

>No, SQL Server does not support ORDER BY or GROUP BY on a column alias. You can use a derived table to get around such limitations. In most cases the execution plan will be the same.
>

>SELECT* FROM (
>  SELECT [New].[Numero] AS FTNumero,New.AddDate,New.Titre AS Title,New.Numero,New.ModDate,New.Url
>    FROM [New]
>     WHERE New.Type=@Type AND New.Status=@Status AND New.NoMember=@NoMember
>  ) dt1
>    ORDER BY UPPER(Title)
>

>
>BTW, why do you use UPPER() in the ORDER BY? Is this column case sensitive?
>
>>I thought SQL Server was supporting the ordering on an AS field. Can someone confirm me that this is not supported:
>>
>>

>>DECLARE @Type Integer
>>DECLARE @Status Integer
>>DECLARE @NoMember Integer
>>
>>SET @Type=4
>>SET @Status=2
>>SET @NoMember=49716
>>
>>SELECT [New].[Numero] AS FTNumero,New.AddDate,New.Titre AS Title,New.Numero,New.ModDate,New.Url
>>  FROM [New]
>>   WHERE New.Type=@Type AND New.Status=@Status AND New.NoMember=@NoMember
>>   ORDER BY UPPER(Title)
>>

>>
>>Basically, to have this working, I have to do this:
>>
>>

>>DECLARE @Type Integer
>>DECLARE @Status Integer
>>DECLARE @NoMember Integer
>>
>>SET @Type=4
>>SET @Status=2
>>SET @NoMember=49716
>>
>>SELECT [New].[Numero] AS FTNumero,New.AddDate,New.Titre AS Title,New.Numero,New.ModDate,New.Url
>>  FROM [New]
>>   WHERE New.Type=@Type AND New.Status=@Status AND New.NoMember=@NoMember
>>   ORDER BY UPPER(New.Titre)
>>