MarkLogic 10 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

MarkLogic 10 Product Documentationsql:strpos

Summary

Example

MarkLogic 10 Product Documentation
sql:strpos