Hi Jaap, I believe you are correct. The CLOB field is memo. The revised SQL code was able to read in the table successfully: create view OC_LOBS as select * from connection to ODBC(select to_char(value_text_clob), response_id, clinical_study_id, DCM_question_ID from RXC.RESPONSE_LOBST); Thanks all for your help. Rob
... View more