oracle - Check for multiple values within CASE statement -

oracle - Check for multiple values within CASE statement -

how check multiple things in case statement without writing multiple lines, checking each case.

i tried , it's ugly.

i want clean below can't create work.

select case when (upper(name) in ('%avg%', '%average%') , formatted_entry not in('<', '>')) formatted_entry end actual_avg values_table

assuming want wildcard matching on percent signs:

case when ( ( upper(name) '%avg%' or upper(name) '%average%' ) , formatted_entry not in('<', '>') ) formatted_entry end actual_avg

oracle case