Skip to content

RIGHT ​

Returns the specified number of rightmost characters from a character string.

Reporting Areas(s) ​

General

Required Parameters ​

  1. Field to return rightmost characters from (i.e. nmfirm, pynumber)
  2. Numeric return value: the number of characters to return (i.e. 4, 10)

Optional Parameters ​

None

Example(s) ​

RIGHT(pynumber,4) returns the last 4 digits of the pynumber. Used mostly to return the right 4 digits of a credit card.

Notes ​

Standard FoxPro function

SUBSTR