Right

The Right() function returns the rightmost characters of a text value. The number of characters that is returned is set with the num_chars parameter.

If num_chars is larger than the number of characters in string, the complete text is returned. If num_chars is 0, an empty text is returned.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns a text value containing the last num_chars characters of string, counted from the right.

Syntax

Right(string, num_chars)

Right("WEM Platform", 8) &#xNAN;=> "Platform"

Right("WEM", 10) &#xNAN;=> "WEM"

Parameters

Name	Type	Required	Description
string	Text	☑️	the text value you want to take the characters from
num_chars	Number	☑️	the number of characters to return, counted from the right