There are two functions that look for text within text, SEARCH() and FIND(). The only difference between the two is that SEARCH() ignores case, while FIND() does not. The syntax for both functions is
FUNCTION(short_string, long_string, start_number)
Here’s are some examples that demonstrate the case issue.
That’s not correct, there’s another difference — SEARCH supports wildcards *, meaning any string, and ?, meaning any character, while FIND does not.
Search does not support wildcards characters like ?,* while find does