I seem to be having difficulty searching for text in multiline text box in a workflow. I am manually populating a column based on items from another child list. I decided to write "NO DATA" into the Status Field, also multiline, when no transactions were present in the detail list. I'd like to be able to query that textbox for the existence of "NO DATA" but my queries don't seem to identify any of the lines.
I've tried a couple of things in the selection such as "equal to" and "NO DATA" also "begins with" since it's the only thing in the text box.