Right

Returns the specified numberOfCharacters in text, counting from the right.

Format 

Right ( text ; numberOfCharacters )

Parameters 

text - any text expression or text field

numberOfCharacters - any numeric expression or field containing a number

Data type returned 

text

Originated in version 

6.0 or earlier

Example 1 

Right ( "Manufacturing" ; 4 ) returns ring.

Example 2 

Right ( Name ; Length ( Name ) - Position ( Name ; " " ; 1 ; 1 ) ) returns Cannon, when the Name field contains Michelle Cannon.

Example 3 

Right ( SerialNumber ; 3 ) & Upper ( Left ( LastName ; 4 ) ) returns 187FERR when the SerialNumber text field contains 00-48-187 and LastName contains Ferrini.

Related topics