Hi ,

has any body come across a oracle function or user defined function , which can retrieve following data .

eg : a particular column in my table contains following data

colA
------
abcdef
adfavs
cdefab
fecdab
adfbce

looking for the following out put after searching 'cde' values .
eg : something like find(colA , 'cde' )

abcdef
fecdab
cdefab
adfbce

any suggestions or script will be highly appreciated .