> >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 > >If you want distinct data in your cursor and you have long memo (more than 254 chars) you would have to use procedural code (scan /endscan with locate for)