It's invalid query because "MyTable.MyField" isn't either aggregate function nor it's included in the GROUP BY.

>It is "MyTable.MyField"
>
>>What's value of lcExpr?
>>
>>>I get error 1803: SQL: Having clause is invalid in the following SQL Select:
>>>
>>>

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

>>>
>>>Can someone, please, point to me on what is wrong with the above expression?
>>>
>>>Thank you.