Contains not working

[doublej]

I am attempting to use Contains to find text.  I have attached an example.  I would expect both records to return true.  Why would they not, isn't contains looking for an instance of the string not an exact match?

[OllieClarke · Accepted solution]

You have your string and field the wrong way round. CONTAINS([Field1],'Jason') is what you're after

[Thableaus]

Hi @doublej 

The first thing to be evaluated is your Field. The string "target" should be "Jason".

The original function is Contains(String, Target)

Cheers,

[doublej]

that was it.  I was thinking that when I saw the structure as Contains(String,Target) it was the string I was looking for in the field (target).  thanks!