Things I have tried
What I’m trying to do
I have a query to record SpamCalls. If I don’t have something after the numeral, I get a null response from the query. If I have something after the numeral, then I get the expected response. So SpamCalls:: 2 will not be returned in the query. But SpamCalls:: 2 = I will get the expected results.
Here is my query:
Table SpamCalls as "Spam Calls"
from "Daily Notes"
where contains(SpamCalls,"")
sort file.name asc
I get the following report if there is something after the numeral:
I’m sure I’m missing something but I have tried a number of different queries and can’t get it to work.
Thanks for your help!