Skip to main content

RIGHT function

Returns the specified characters from the right side of a string.

Syntax

RIGHT(string, length)

Arguments

  • string: a string expression.

  • length: an integer value that specific how many characters to return.

Returns

A string, that contains specified characters from the right side of the input string. If length is less than or equal to 0, returns an empty string.

Examples

> SELECT RIGHT('CeloSQL', 3);
 SQL