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