Reference > Functions reference > Text functions > Right
 
Right
Purpose 
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 
FileMaker Pro 6.0 or earlier
Examples 
Right ( "Manufacturing" ; 4 ) returns ring.
Right ( Name ; Length ( Name ) - Position ( Name ; " " ; 1 ; 1 ) ) returns Cannon, when the Name field contains Michelle Cannon.
Right ( SerialNumber ; 3 ) & Upper ( Left ( LastName ; 4 ) ) returns 187FERR when the SerialNumber text field contains 00-48-187 and LastName contains Ferrini.
Related topics 
Functions reference (category list)
Functions reference (alphabetical list)
About formulas
About functions
Defining calculation fields
Using operators in formulas