Use the SEARCH function to get the location of one text string inside another. SEARCH returns the position of the first character of find_text inside within_text. Unlike FIND, SEARCH allows the use of wildcards, and is not case-sensitive.
SEARCH allows the wildcard characters question mark (?) and asterisk (*), in find_text. The ? matches any single character and the * matches any sequence of characters. To find a literal ? or *, use a tilde (~) before the character, i.e. ~* and ~?.