Comments
-
Use the CONCAT function and concatenate the wild cards(* or % for example) around the variable name that represents the text input. So for example WHEN 'ITEM_DESC' LIKE CONCAT('%', 'keyword search Notes', '%') THEN 'TRUE' Concat returns the value of the text input with the wildcards on both sides as a string which is what…
-
Thanks so much @MarkSnodgrass ! We will try your workaround and report the bug, thanks again!
