>In VFP5.0a I cant seem to select a distinct field if it's a memo field? If I do -
>

>SELECT DISTINCT baseclass FROM (lcVCXfile) INTO CURSOR (lcTempFile)
>

>I get Error 34, Operation is invalid for a Memo, General, or Picture field. (baseclass is a memo field) Yet I can do the same query without the DISTINCT clause and it is just fine. I also tried some string manipulation stuff, but it still doesnt seem to want to mix and match DISTINCT with a memo. Any ideas on how I can do this without writing multiple statements? TIA!

If you want to select just some fields DISTINCTevily and don't care what you will get in other fields, then you can:
Select field1,field2,filed3,memofield From ... Group by 1,2
i.e. you will get distinctive Field1,Field2 and just one of possible many field3,memofield (usually, grouping retains the last record from each group).