INSERT(string1, start, length, string2) A character string formed by
deleting length characters from string1 beginning at start,
and inserting string2 into string1 at start.
LOCATE(string1, string2[, start]) Position in string2 of the first
occurrence of string1, searching from the beginning of string2;
if start is specified, the search begins from position start.
SOUNDEX(string) A character string, which is data source-dependent, representing the sound of the words in string; this could be a four-digit SOUNDEX code, a phonetic representation of each word, etc.