use or operator within like regex expression

Community Support
1

I need to match a string that includes either of two strings in pattern - *STR1* or *STR2*.
e,g
select from t where c like “*((STR1)|(STR2))*”

I cannot do select from t where c like “*STR1*” or c like “*STR2*”   
due to way UI flows these filters in to backend
.

Any suggestions?

Thanks!

2

Looking at the string pattern, there is another way

q)select from t where c like “*STR[1-2]*”

3

Spot on for this example :)