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