MarkLogic 10 Product Documentation
sql:left

sql:left(
   $str as xs:anyAtomicType?,
   $n as xs:double?
) as xs:string?

Returns a string that is the leftmost characters of the target string. The number of characters to return is specified by the second argument.

Parameters
str	The base string. If the value is not a string, its string value will be used.
n	The number of leftmost characters of the string to return.

  sql:left("abcde",2)
  => "ab"

MarkLogic 10 Product Documentationsql:left