So, I am able to use Lookup() to search for an exact term but how can I use lookup if i want search results that matches the search term.
If my data extension rows include values like "White Car", "Blue Car", "Black Car" etc.
I want to search for "Car" and lookup should display all values that are includes the search term "Car". Is it possible?
set @searchlookup = "car" set @RowsReturn = 0 set @srows = LookupOrderedRows("Data_Extension","Column_Name", @searchlookup)
How can I search with some kind of wildcard in the search term?