>Hi
>
>I'm doing
>
>SELECT MyCursor.Campo1, MyCursor.Campo2 ;
> FROM MyCursor ;
>WHERE "ABC" $ MyCursor.Campo2 ;
>INTO CURSOR MyCursor2
>
>and I want a cursor MyCursor2 that has all the records where Campo2 contains the string "ABC".
>But it doesn't filter anything, it just brings all the records.
>What am I doing extremly wrong?
>Thanks
>Hernan


Hernan,

Add the NOFILTER option to your select statement;

SELECT MyCursor.Campo1, MyCursor.Campo2 ;
   FROM MyCursor ;
WHERE "ABC" $ MyCursor.Campo2 ;
INTO CURSOR MyCursor2 NOFILTER

In order to optimize the speed of your select VFP may be simply using the original cursor (MyCursor) with a SET FILTER on it. By using the NOFILTER option you are telling VFP "never mind how fast you can do it just make sure you actually create a new cursor with only the records I want in it."