Hi,
We need a column which can store more than 4000 characters of data approx 20,000 characters need to be stored in that column and we need to be able to query the data based on a where clause or more specifically key words.

I read somewhere that CLOB is better than long datatypes but both have restrictions.

Whats the best way of doing this and how.

I am using Oracle 8.1.7 on a windows 2000 machine.

Thanks
Ronnie