3.2.41. POS(needle,haystack[,start]) Seeks for an occurrence of the string needle in the string haystack. If needle is not found, then 0 is returned. Else, the position in haystack of the first character in the part that matched is returned, which will be a positive whole number. If start (which must be a positive whole number) is specified, the search for needle will start at position start in haystack. POS(‘be’, ‘to be or not to be’) –> 3 POS(‘to’, ‘to be or not to be’, 10) –> 17 POS(‘is’, ‘to be or not to be’) –> 0 POS(‘to’, ‘to be or not to be’, 18) –> 0
PREV NEXT