Filter collection - Contains / wildcard

[samuel_a_thomas]

Dear All, I am looking for a way to filter my collection based on several filter + contains functionality . I know that, As input in the action stage we write the filter as following : "[ColumnName]='"&[data we want]&"'" But Know i would like to filter on a field containing the word "SAM" for example so I try these expression: "[ColumnName]='"& "*SAM" &"'" and as well "[ColumnName]='"& "%SAM" &"'" But nothing is working ? could you please help me ? Thanks a lot if someone has already succeed with this, I will be a huge help for me !!! Best regards

[John__Carter]

Try [Column Name] LIKE '*SAM'

[shahariar_k_bhu]

What about filtering using InStr function? InStr([Column Name]; ""SAM"") > 0

[WimLogister]

Just want to confirm that John's ""LIKE"" pattern works great.

[SébastienBulté]

Just to elaborate, the filter action uses SQL syntax (like this: https://www.w3schools.com/sql/sql_like.asp )