>With the new CAST function, you can now handle VFP memo fields better. For example, I want a distinct set of ClassLib names used in a form:

>SELECT DISTINCT CAST(JUSTFNAME(classloc) as V(60)) ClassLoc ;
>   FROM forms\techcalls.scx ;
>   WHERE NOT EMPTY(ClassLoc) ;
>   INTO CURSOR crsLibs

>Cool, eh?

vfp8 and before ( except trim this is equal )

SELECT DISTINCT LEFT(JUSTFNAME(classloc),60) ClassLoc ;
   FROM forms\techcalls.scx ;
   WERE NOT EMPTY(ClassLoc) ;
  INTO CURSOR crsLibs