Try converting it to a sting. For example:

select distinct allt(baseclass) as descript from (lcVCXFile)

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