>SELECT substr(dtos(ADDDATE),6) as yearmonth, * ;
>FROM THREAD;
>WHERE NOMEMBER=lnNumero AND NOCLIENT=lnWeb;
>INTO CURSOR TEMP;
>ORDER BY 1
I tested it and it is extremly slow because of the evaluation. I think it's better to begin with SELECT ADDDATE FROM THREAD... and then work from this one.