Comments
-
Hi, thank you very much for the formula. while I was playing around I've done it like this. case when ITEM_DESC like concat('','%',Search Notes,'%','') then 'True' else 'false' END I've then compared the results and my variant was giving 5 more results. So I wrapped what u gave me into LOWER() and it stopped caring about…
