>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!
SELECT DISTINCT PADR(CLASS,254) FROM BIBLIOTK.VCXbut it shows only the first 254 bytes of CLASS. (254 is the longest posible C field.)