The LOCATE function returns a large integer indicating the position of one string, searchString, in another, sourceString. The function returns 0 if searchString is a zero-length string or is not found, or if start is greater than the length of sourceString. By default, the search starts at the first character of the receiving string (that is, the value of start is 1), and continues to the end of the string.