... order by 3 -- titleFor the ORDER BY clause you can use the column number. You can not use the column number in the GROUP BY clause.
> >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) >