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?
Mark McCasland
Midlothian, TX USA