>>>>>>It's invalid query because "MyTable.MyField" isn't either aggregate function nor it's included in the GROUP BY.
>>>>>>
>>>>>
>>>>>I changed the SQL Select, making Group By "1,2" (instead of just 2) and it works now.
>>>>>
>>
>>But it is different.
>>
>
>Fabio,
>
>You are saying that change Group By from 2 to 1,2 changes the result of the SQL Select, right? If so, I understand and agree. But it makes the SQL Select work without giving me the error. Also, since both 1 and 2 point to the same field (2 being just an upper case version of it), I don't think it changes the result, really.
>
>Unless I am missing something, which would not surprise me <g>.

This is the way, but it open THIS ISSUE: "the first fieldname is undefined":

select MAX(&lcExpr), ;
   upper(&lcExpr) ;
   from (tcAlias) ;
   where not deleted() ;
   &lcFilter ;
   group by 2 ;
   having not empty(&lcExpr) ;
   into cursor (.cCursor)