MarkLogic 9 Product Documentation
sql:strpos

sql:strpos(
   $target as xs:string?,
   $test as xs:string?,
   [$collation as xs:string?]
) as xs:integer?

Summary

Returns an integer value representing the starting position of a string within the search string. Note, the string starting position is 1. If the first parameter is empty, the result is the empty sequence.

Parameters
target The string from which to test.
test The string to test for existence in the second parameter.
collation The optional name of a valid collation URI. For information on the collation URI syntax, see the Search Developer's Guide.

Example

sql:strpos("searchintext","chin")

=> 5
Powered by MarkLogic Server | Terms of Use | Privacy Policy