>Mark,
>
>I dropped a table I had with a LONG field. I executed the script to re-build it with a CLOB field instead. After re-installing the data I was still not able to use SUBSTR()
>
>SELECT SUBSTR(ADDR_DTL.ADDR_LINE, 1, 30) AS ADDR_LINE1, SUBSTR(ADDR_DTL.ADDR_LINE, 31, 60) AS ADDR_LINE2 FROM ADDR_DTL WHERE ADDR_DTL.ADDR_NO = 4311
>
>Am I miss-using SUBSTR()
Not that I know of. I am using Oracle 9.0.2, and it works for me. What is the error message?
Mark McCasland
Midlothian, TX USA