What is the usual formula that we type in the query criteria box of MS Access to get results, such as (Like "*" & "RajPoot" & "*") or (Like "*" & "Malak" & "*")?

edit

The usual formula that we type in the query criteria box of MS Access to get results is the use of wildcards with the Like operator. The syntax for this is:

Like "" & [SearchTerm] & ""

Where [SearchTerm] is the value you want to search for. The "*" are wildcards that represent any number of characters before and after the search term, allowing for more flexible and accurate search results.