Re: SQL Query- filter on text in CLOB

D wrote:
> How can I writ the simplest query to select all the IDs from a table
> where a certain string is present in a CLOB field?
>
> I want to do a LIKE comparison, but that doesn't work. I looked at
> dbms_lob.instr and dbms_lob.substr but neither seem to work right. I
> tried to_char in the where clause, but I probably have the syntax
> wrong.
>
> If anyone can point me to the absolute fastest way to write this query
> let me know.
>
> thanks!
>
> Don

InterMedia

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)