>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!

I tried this, and it works:

SELECT DISTINCT PADR(CLASS,254) FROM BIBLIOTK.VCX

but it shows only the first 254 bytes of CLASS. (254 is the longest posible C field.)