RIGHT

The RIGHT function returns a string of length length containing the rightmost length characters of string.

Read syntax diagramSkip visual syntax diagram RIGHT( string , length ,pad )

The string returned is padded with pad characters (or truncated) on the left as needed. The default pad character is a blank. The length must be a positive whole number or zero.

Examples

RIGHT('abc  d',8)     ->    '  abc  d'
RIGHT('abc def',5)    ->    'c def'
RIGHT('12',5,'0')     ->    '00012'