RIGHT

Returns a substring from the end of a specified string.

Usage examples 

  • RIGHT("abcdefg", 2)

  • RIGHT(tableA.fieldB, 3)

Syntax 

RIGHT ( value, [ number ] )

  • value - any string expression representing from which the right portion will be returned.

  • number - any numeric expression representing the number of characters to return from the right side of string.

Returns 

string - the substring from the right.

Functions reference