% is a wild card.

where blah_field like '%zoo'

Of course, if case is a problem, you can use

where upper(blah_field) like '%ZOO'

__________________
Because Every Child Deserves a Chance to Play Baseball in El Paso