I queried from my sheet but its case sensitive. How can I remove it? My query as below:
=ArrayFormula(IFNA(IF(QUERY('pending SKUs'!E2:AQ,"select F, G, H, L, M, N, O, I where E='tree' AND P <> 2 AND P <> 3 AND X='Pass' AND AQ <> 'Rejected'")="",0,
QUERY('pending SKUs'!E2:AQ,"select F, G, H, L, M, N, O, I where E='tree' AND P <> 2 AND P <> 3 AND X='Pass' AND AQ <> 'Rejected'")),""))
I want to include "tree tree", "TREE tree", "Tree tree" and any other possible case used between all the alphabets.
Explanation
QUERYthe range in this caseA:Cwrapped with{}Array so that we would utilizeCol1, Col2,...instead ofA, B,...in the query.Notice we got all diffrent cases by setting the query to
" SELECT * WHERE lower(Col1)='tree tree' "Meaning select everythig*where column 1Col1is lowercaselower(Col1)is equal to'tree tree', and in all cases it does.

