Rows where any of columns contains term, ignoring case: upper(col) like upper('%term%') escape '\'. The term is a bind, and its % and _ match themselves. An empty term leaves the query as it is.
columns
term
upper(col) like upper('%term%') escape '\'
%
_
Rows where any of
columnscontainsterm, ignoring case:upper(col) like upper('%term%') escape '\'. The term is a bind, and its%and_match themselves. An empty term leaves the query as it is.