Michel,

I didn't see anyone suggest this yet.

...
   order by 3 -- title

For the ORDER BY clause you can use the column number. You can not use the column number in the GROUP BY clause.

>I thought SQL Server was supporting the ordering on an AS field. Can someone confirm me that this is not supported:
>
>

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