right

Retrieve the rightmost characters from a string

Syntax

right(string_expr,num)

Arguments

string_expr	A string expression.
num	The number of the rightmost characters to return.

Description

This scalar string function returns the specified number of characters from the rightmost part of a string.  The string parameter can be an ASCII string or a Unicode string.  If a Unicode string is specified, the function returns a Unicode string.