>>VARCHAR2's max size is 4000 - at least that what the Oracle devs I'm working with say. :)
>
>Thanks. So much to learn. 4k is probably enough MOST of the time. The 1-1 table could be used for overflow in my case.

Yep, I would say so.
We're working on a VFP to Oracle conversion right now and have reduced the number of true memo fields (i.e., ones that will be LONG) from 143 to 4.