SELECT ACTIV, VENDR# AS CARNBR, CORPVN AS CARCRP, TRIM(AGENCY) AS CARNAM,
CASE WHEN CONTAINS(DLAD3,'  ') = 1 THEN REPLACE(TRIM(DLAD3),'  ',',') END AS CARCTY,
TRIM(DLSTA) AS CARSTE,
 TRIM(DLZPPF) AS ZIPPRE,
 TRIM(DLZPBS) AS   ZIPBSE,
TRIM(DLZPSf) AS ZIPSUF,
 TRIM(CARAB) AS CARAB ,
 TRIM(CARTY) AS CARTY,
TRIM(ICC#) AS ICC,
TRIM(AGTYP) AS AGTYP
FROM TSPRP100
WHERE VENDR#=707071