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)
>