Just a quick note....
If you draw in the whole table normally...
sample:
FROM OPENQUERY([HEPRD-COURSES],
'SELECT * FROM PS_ZVSR_CLASS_NOTE') [zClassNote]
try casting the offending field
sample2:
FROM OPENQUERY([HEPRD-COURSES],
'SELECT CLASS_NOTES_SEQ, CAST(SUBSTR(DESCRLONG,1,4000) AS VARCHAR2(4000)) as DESCRLONG, CRSE_ID, CRSE_OFFER_NBR, STRM,...