Search for text within long field?`

Is there a way to search for a text string that might exist in a long field?

Something like

SELECT	text
FROM	all_views
WHERE	instr(text,'my search') > 0

Thanks,

Craig Buchanan Received on Mon Jun 04 2001 - 15:00:56 CDT