Trying to do --


select instr(comment, 'order')
from ordered_qunatities
where sales_id = '704891'

Im trying to search for the word order in the comment field, which is of datatype long?

the instr function will not work for me on the long datatype?

Is there an easy way around this?

Many thanks for any help