Loading TOC...

sql.strpos

sql.strpos(
   $target as String?,
   $test as String?,
   [$collation as String?]
) as Number?

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

Stack Overflow iconStack Overflow: Get the most useful answers to questions from the MarkLogic community, or ask your own question.