Re: how to include a partial field in this view?

So, can you do this:
SELECT
T01.OHORDD, T01.OHORDT, T01.OHJOB3, T01.OHORD#,
T01.OHOSTC,
M.MHZONE
FROM
ASTDTA.OEORHDOH T01
LEFT OUTER JOIN
SHP4VAR27F.MFH1MH M
ON T01.OHORD# = left(M.MHORDR, 8)
WHERE
T01.OHORD#='02576661'

I went to a lot of work...
CREATE TABLE ROB/OEORHDOH (OHORDD DATE NOT NULL, OHORDT TIME NOT
NULL, OHJOB3 INT NOT NULL, OHORD# CHAR (8 ) NOT NULL, OHOSTC CHAR
(2 ) NOT NULL WITH DEFAULT)

INSERT INTO ROB/OEORHDOH VALUES('2013-10-03', '15.38.00', 12345,
'02576661', 'CL')

CREATE TABLE ROB/MFH1MH (MHORDR CHAR (11 ) NOT NULL, MHZONE CHAR (2
) NOT NULL)

INSERT INTO ROB/MFH1MH VALUES('02576661000', 'IN')

SELECT
T01.OHORDD, T01.OHORDT, T01.OHJOB3, T01.OHORD#,
T01.OHOSTC,
M.MHZONE
FROM
OEORHDOH T01
LEFT OUTER JOIN
MFH1MH M
ON T01.OHORD# = left(M.MHORDR, 8)
WHERE
T01.OHORD#='02576661'

....+....1....+....2....+....3....+....4....+....5....+....6..
OHORDD OHORDT OHJOB3 OHORD# OHOSTC MHZONE
2013-10-03 15:38:00 12,345 02576661 CL IN
******** End of data ********



Rob Berendt