how to include a partial field in this view?

We have here 3 files which are linked basically by Order number. there is
one more file we need to use to get the Shipping zone code, from the
"Varsity" system. This field however is 10 pos. whilst the others are all
8. We want to join on MHORDR in the file SHP4VAR27F/MFH1MHL0, then we are
done. How am I to add this in here?

SELECT
ALL T01.OHORDD, T03.IHINV#, T01.OHORDT, T01.OHJOB3, T01.OHORD#,
T02.IDPRLC, T02.IDNTU$*(IDSHP#) AS EXTSHP, T02.IDPRT#
FROM ASTDTA/OEORHDOH T01 LEFT OUTER JOIN
ASTDTA/OEIND1 T02
ON T01.OHORD# = T02.IDORD# LEFT OUTER JOIN
ASTDTA/OEINHDIH T03
ON T01.OHORD# = T03.IHORD#
WHERE T01.OHOSTC = 'CL'
AND T01.OHORDD >= 20120101
ORDER BY T01.OHORD# ASC