Good morning.
I am running a SQL statement that returns too much rows... even if I have a where criteria, it does not take out the records !

There is it.
SELECT calias, count(calias) as ncount, coption FROM curpos2 where alltrim(curpos2.coption)='O' GROUP BY calias, coption INTO CURSOR curtmpstock

I get this :
CALIAS, NCOUNT, COPTION
"AMNG" 2 empty
"AMNG" 3 "O"
"AOL" 2 empty
"AOL" 5 "O"

Why does this SQL statement keep the empty COPTION ?

I am using VFP7 SP1.