Hi friends:

This is what I always wanted to do but I've never got it.

Anyone can tell me what is the correct way for "grouping by" in a SELECT SQL command?

I tried FROM field table, INTO CURSOR field and 1 (result column field) and none of them worked.

This is just one of my tests:

   SELECT SUBSTR(f850nfac,2,4) as cpues, f850grav as cgrav, f850ivai as civai, f850exen as cexen, f850tota as ctota, .t. as celijo ;
          FROM &ivaventa WHERE LEFT(DTOS(f850ffac),6)==thisform.peri GROUP BY CPUES NOCONSOLE INTO CURSOR cpuesto

Thank you.

Héctor