>
>MyNumericField     MyMemoField
>
>1                  Blah
>2                  BlahBlah
>2                  BlahBlah
>3                  BlahBlahBlah
>
>I only want:
>
>1                  Blah
>2                  BlahBlah
>3                  BlahBlahBlah
>
>But I can't group by a memo field, so how can I get this to work:
>
>SELECT MyNumericField, MyMemoField FROM MyTable INTO MyCursor
>
>

select distinct myNumericField from myTable into cursor crsTemp 
&& from your original SQL only memo field is removed

select tmp.*,myMemoField ;
 from myTable inner join crsTemp tmp on myTable.myNumericField = tmp.myNumericField ;
 into cursor myCursor [readwrite]