Thanks.
Now it works !
Good ideas !


>>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.
>
>Either set ansi on or use == operator.
>
>ie:
>

create cursor mycursor (myvalues c(10))
>for ix = 1 to 10
>	insert into myCursor values ('O'+trans(ix))
>endfor
>insert into myCursor values ('O')
>insert into myCursor values ('')
>
>set ansi off
>select * from myCursor where myvalues = 'O'
>select * from myCursor where alltrim(myvalues) = 'O'
>select * from myCursor where myvalues == 'O'
>select * from myCursor where alltrim(myvalues) == 'O'
>
>set ansi on
>select * from myCursor where myvalues = 'O'
>select * from myCursor where alltrim(myvalues) = 'O'
>select * from myCursor where myvalues == 'O'
>select * from myCursor where alltrim(myvalues) == 'O'
>

Cetin