In SFMC, Contact Builder has the functionality to search records if it has a primary key column (only primary key columns can be used to search, if a DE has no primary key it is not possible to search)

Normally we need to give the entire string or first part of a string to get a successful search result. But what if you want to get result using any part of the string (eg: using 'LIKE' in SQL)??

Yes, It is possible!!

By adding two '%' (percentage symbol) at the beginning and end of the search string, we can search for any occurrences of the search string.

Example: 

In the below image, if we search 'Rahman', only name starting with the search string will appear as result. But if you search with '%Rahman%' all the records which have the search string will appear.