i liked db2 istead of oracle for this purpose

db2 has somthing like translate(column_name) like '%me%' and it does it for me for all cases....
and i assume we dont have such a thing in oracle...do we?

thanx