I have a scenario where my in clause should compare string value. For string *i* do an upper on the left and right of the in clause like below

```
select * from cases where upper(case_name) = upper(String);//value passed dynamically.

```

Now, this value is a multi-select field. So there may be more than 1 string. In that case what is the best approach to compare values.

```
select * from cases where upper(case_name) = upper('ABC');//value passed dynamically with 1 selection.

select * from cases where upper(case_name) = upper('ABC', 'BCD');//value passed dynamically with more than 1 selection.this query wont work but just showing the requirement.

```

Please let me know which would be the best approach. I have to do this in java with hibernate native query. So keeping that in mind please suggest. thank you.