How do I search a long column for a text string in it?

I obviously cannot use "LIKE" because sql gives an error

ORA-00932: Inconsistent datatypes