I actually answered the same question by Dmitry about a week or so ago.

Re: Is GROUP_ID reserved word? Thread #1387014 Message #1387020

BTW, in both cases (VFP and SQL Server) you would have to include UPPER(Title) in the field list and used it as derived table.

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