Thanks Tim! I'll check it out.

Del

>For LOBS you can use.
>
>a) DBMS_LOB.INSTR Check out DBMS_LOB in the Supplied Packages Documentation I cant remember the syntax..
>http://download-uk.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a89852/dbms_lob.htm#1002572
>
>
>b) Intermedia Text...CTXSYS.CONTEXT
>This has a lot of cool stuff like fuzzy search, near ect...And is a lot easier than you might think..
>
>
>
>>How do you accomplish this for LONG or LOB fields in oracle?