>>Can I cheat and use NVL(TO_CHAR(SomeClobFld), ???)
>
>Wow! That actually works!

Unfortunately not in 8i

>
>One other good point about CLOB is you can have more than 1 of these data types per table. You can only have 1 LONG per table.

This is great to hear. This works in 8i. That will save me some trouble.

Thanks.
Mike