Filter when Field Contains the Text in Arcade

[JustinH]

Hello- 

I am currently trying to filter a dataset by using an expression in Dashboards. The expression does more than just this filter so I cannot use the handy dandy filter tool within elements. 

What I want my expression to say is Filter(dataset, feature 'contains the text' "State"). 

It seems fairly simple but I am having a hard time figuring this out. I tried following some of the suggestions from jcarlson in this post: 

Solved: Arcade Expression for field "includes" a value - Esri Community

However, I am not really sure how to integrate this Split + Includes or the Find workflow into my filter function. 

Here is a more Specific Code: 

// Filter the FeatureSet for "State Trust" in the FUNDING_SOURCE field using Includes

var statelands = Filter(fs, Includes('FUNDING_SOURCE', 'State Trust'))

TIA! 

[KenBuja · Accepted solution]

You can use the "Like" operator in the sql statement

filter(fs, "FUNDING_SOURCE Like '%State%'")

[JustinH]

YES! Thank you so much!