Loading TOC...

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"

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