MarkLogic Server 11.0 Product Documentationsql: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"