After posting, I realized I needed to check ALLTRIM(). The following line works in both VFP 7 & 8.

SELECT SUBSTR(a1.bb, 1, LEN(ALLTRIM(a1.bb))) AS DD from a1 INTO CURSOR c1

John