RIGHT

Read syntax diagramSkip visual syntax diagram
>>-RIGHT--(--string--,--length--+--------+--)------------------><
                                '-,--pad-'      

returns a string of length length containing the rightmost length characters of string. 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.
Here are some examples:
RIGHT('abc  d',8)     ->    '  abc  d'
RIGHT('abc def',5)    ->    'c def'
RIGHT('12',5,'0')     ->    '00012'


right.html | Timestamp icon Last updated: Monday, 5 June 2017