Where Statement

[#1]

If i wanted to add in a where statement to show any customer containing a certain word or words how would i write that? i want to only show 1 customer out of lets say 20 customers but that one customer has 10 different stores, so how could i say i want to see everything containing that main name of that customer?

Ex. CUSTOMER (just want to show everything that includes this word so it would include both of the below)

          - CUSTOMER123

          -CUSTOMER456

thanks for the help!

[MK_QSL · Accepted solution]

Load Customer, * from TableName

Where Wildmatch(Customer,'*SearchField*');