title: OBIEE: filter that supports "LIKE" and "IN"
body: <p>OBIEE:  How can I make a filter that supports "LIKE" and "IN", so for example, the user can enter in the analysis prompt either A3%  or  A31;A34;A3C</p>
  
  <p>1) This works for IN: UPPER("Fund Status - Direct"."Proj Nbr") IN (@{V_PROJ_NUMBER}[UPPER('@')]{UPPER("Fund Status - Direct"."Proj Nbr")}) </p>
  
  <p>2) This works for LIKE: UPPER("Fund Status - Direct"."Proj Nbr") LIKE (@{V_PROJ_NUMBER} [UPPER('@%')]{UPPER("Fund Status - Direct"."Proj Nbr")}) </p>
  
  <p>3) When I try to combine them in the Criteria filters, the LIKE filter crashes when user enters a delimited string such as A1;A2</p>