MarkLogic 10 Product Documentation
sql:right

sql:right(
   $str as item()*,
   $n as xs:double?
) as xs:string?

Summary

Returns a string that is the rightmost 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 rightmost characters of the string to return.

Example

  sql:right("abcde",2)
  => "de"
Powered by MarkLogic Server | Terms of Use | Privacy Policy