Hi All,

Is there a way in a query to convert data stored in a CLOB field into a Character field? In the following query the field 'ADDR_LINE' is the field I'd like to convert. If I could get only the 1st row of the field. That would be ok. Or the 1st 2 rows into 1 row, even better.

lcSqlStatement = "SELECT addr_no, cust_no, ADDR_LINE, city, " +;
	         "state_cd, cntry_cd, zip_cd " +;
                 "FROM addr_dtl " +;
                 "WHERE addr_dtl.addr_no = " + TRANS(lnCustAddrNo)

TIA
Mike