Thank you again for your comments. I have plugging away at SPT and have found that there seems to be a limit on the length I can pass. I have VFP 7.0 and MS-SQL2000. This gives an error while eliminating ", T1.CUSTCHAR6 " seems to work.

? SQLEXEC(gnConnHandle,"SELECT T1.ACTIVE, T1.WEB_ACTIVE, T1.DEF_VENDPO, T1.ITEMNO,;
T1.CATEGORY, T1.BRAND, T1.MODEL, T1.DESCRIPT,;
T2.LEVEL_CODE, T1.CUSTCHAR5, T1.CUSTCHAR6 ;
FROM items AS T1 LEFT OUTER JOIN Item_cust_level_detail AS T2 ON T1.ITEMNO = T2.ITEM_CODE WHERE BRAND = 'BRANDID'")

Looks like I will have to build views and just get it done unless you have a better idea.