I do get an "inconsistent datatypes" error against an Oracle 8i database, but it does work in 9i.
>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
Mark McCasland
Midlothian, TX USA