You can use DBMS_LOB.INSTR (a built-in Oracle stored proc) to do case-sensitive searches of CLOB datatypes. I used that for searching thetips. And if we had the InterMediaText option, we could add indexing of CLOB types and searching. I'm not sure if InterMediaText comes with Oracle by default (I doubt it). I'm thinking about writing a stored proc to do case in-sensitive search but I'm not sure what kind of performance that we would get. Oh, we'd also have to convert from using LONGs to CLOBs. Dean .jeff writes: > if we *ever* get the search engine working so that it searches the > body of the article as well then it'll be crucial that this > non-article related material doesn't factor into the results.