Hi Mark,

You can get the same results in VFP 6 with this:

select LEFT( ALLTRIM( name ), LEN( ALLTRIM( name ) ) - 1 ) as cName, type as cType ;
from ;
where type <> 'H' ;
order by cType ;
into cursor crsFiles