Dataview Query with an ending numeral

[DJP]

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!

[scholarInTraining]

If you take out your WHERE or change it to just WHERE SpamCalls, does that help?

[DJP]

I did your second option WHERE SpamCalls and it worked! Thank you!!