RIGHT( ) Function

MSDN Home

MSDN
MSDN Library
Development Tools and Language…
Visual FoxPro
Visual FoxPro 9.0 SP2
Microsoft Visual FoxPro 9.0 SP…
Reference
Language Reference
Functions

Functions

Character Functions
Data Conversion Functions
Date and Time Functions
COM Functions
Numeric Functions
XML Functions
$ Operator
% Operator
:: Scope Resolution Operator
ABS( ) Function
ACLASS( ) Function
ACOPY( ) Function
ACOS( ) Function
ADATABASES( ) Function
ADBOBJECTS( ) Function
ADDBS( ) Function
ADDPROPERTY( ) Function
ADEL( ) Function
ADIR( ) Function
ADLLS( ) Function
ADOCKSTATE( ) Function
AELEMENT( ) Function
AERROR( ) Function
AEVENTS( ) Function
AFIELDS( ) Function
AFONT( ) Function
AGETCLASS( ) Function
AGETFILEVERSION( ) Function
AINS( ) Function
AINSTANCE( ) Function
ALANGUAGE( ) Function
ALEN( ) Function
ALIAS( ) Function
ALINES( ) Function
ALLTRIM( ) Function
AMEMBERS( ) Function
AMOUSEOBJ( ) Function
ANETRESOURCES( ) Function
APRINTERS( ) Function
APROCINFO( ) Function
ASC( ) Function
ASCAN( ) Function
ASELOBJ( ) Function
ASESSIONS( ) Function
ASIN( ) Function
ASORT( ) Function
ASQLHANDLES( ) Function
ASTACKINFO( ) Function
ASUBSCRIPT( ) Function
AT( ) Function
AT_C( ) Function
ATAGINFO( ) Function
ATAN( ) Function
ATC( ) Function
ATCC( ) Function
ATCLINE( ) Function
ATLINE( ) Function
ATN2( ) Function
AUSED( ) Function
AVCXCLASSES( ) Function
BAR( ) Function
BARCOUNT( ) Function
BARPROMPT( ) Function
BETWEEN( ) Function
BINDEVENT( ) Function
BINTOC( ) Function
BITAND( ) Function
BITCLEAR( ) Function
BITLSHIFT( ) Function
BITNOT( ) Function
BITOR( ) Function
BITRSHIFT( ) Function
BITSET( ) Function
BITTEST( ) Function
BITXOR( ) Function
BOF( ) Function
CANDIDATE( ) Function
CAPSLOCK( ) Function
CAST( ) Function
CDOW( ) Function
CDX( ) Function
CEILING( ) Function
CHR( ) Function
CHRSAW( ) Function
CHRTRAN( ) Function
CHRTRANC( ) Function
CLEARRESULTSET( ) Function
CMONTH( ) Function
CNTBAR( ) Function
CNTPAD( ) Function
COMARRAY( ) Function
COMCLASSINFO( ) Function
COMPOBJ( ) Function
COMPROP( ) Function
COMRETURNERROR( ) Function
COS( ) Function
CPCONVERT( ) Function
CPCURRENT( ) Function
CPDBF( ) Function
CREATEBINARY( ) Function
CREATEOBJECT( ) Function
CREATEOBJECTEX( ) Function
CREATEOFFLINE( ) Function
CTOBIN( ) Function
CTOD( ) Function
CTOT( ) Function
CURDIR( ) Function
CURSORGETPROP( ) Function
CURSORSETPROP( ) Function
CURSORTOXML( ) Function
CURVAL( ) Function
DATE( ) Function
DATETIME( ) Function
DAY( ) Function
DBC( ) Function
DBF( ) Function
DBGETPROP( ) Function
DBSETPROP( ) Function
DBUSED( ) Function
DDE Functions
DDEAbortTrans( ) Function
DDEAdvise( ) Function
DDEEnabled( ) Function
DDEExecute( ) Function
DDEInitiate( ) Function
DDELastError( ) Function
DDEPoke( ) Function
DDERequest( ) Function
DDESetOption( ) Function
DDESetService( ) Function
DDESetTopic( ) Function
DDETerminate( ) Function
DEFAULTEXT( ) Function
DELETED( ) Function
DESCENDING( ) Function
DIFFERENCE( ) Function
DIRECTORY( ) Function
DISKSPACE( ) Function
DisplayPath( ) Function
DMY( ) Function
DODEFAULT( ) Function
DOW( ) Function
DRIVETYPE( ) Function
DROPOFFLINE( ) Function
DTOC( ) Function
DTOR( ) Function
DTOS( ) Function
DTOT( ) Function
EDITSOURCE( ) Function
EMPTY( ) Function
EOF( ) Function
ERROR( ) Function
EVALUATE( ) Function
EVL( ) Function
EVENTHANDLER( ) Function
EXECSCRIPT( ) Function
EXP( ) Function
FCHSIZE( ) Function
FCLOSE( ) Function
FCOUNT( ) Function
FCREATE( ) Function
FDATE( ) Function
FEOF( ) Function
FERROR( ) Function
FFLUSH( ) Function
FGETS( ) Function
FIELD( ) Function
FILE( ) Function
FILETOSTR( ) Function
FILTER( ) Function
FKLABEL( ) Function
FKMAX( ) Function
FLDLIST( ) Function
FLOCK( ) Function
FLOOR( ) Function
FONTMETRIC( ) Function
FOPEN( ) Function
FOR( ) Function
FORCEEXT( ) Function
FORCEPATH( ) Function
FOUND( ) Function
FPUTS( ) Function
FREAD( ) Function
FSEEK( ) Function
FSIZE( ) Function
FTIME( ) Function
FULLPATH( ) Function
FV( ) Function
FWRITE( ) Function
GETAUTOINCVALUE( ) Function
GETBAR( ) Function
GETCOLOR( ) Function
GETCP( ) Function
GETCURSORADAPTER( ) Function
GETDIR( ) Function
GETENV( ) Function
GETFILE( ) Function
GETFLDSTATE( ) Function
GETFONT( ) Function
GETINTERFACE( ) Function
GETNEXTMODIFIED( ) Function
GETOBJECT( ) Function
GETPAD( ) Function
GETPEM( ) Function
GETPICT( ) Function
GETPRINTER( ) Function
GETRESULTSET( ) Function
GETWORDCOUNT( ) Function
GETWORDNUM( ) Function
GOMONTH( ) Function
HEADER( ) Function
HOME( ) Function
HOUR( ) Function
ICASE( ) Function
ID( ) Function - Network Machi…
IDXCOLLATE( ) Function
IIF( ) Function
IMESTATUS( ) Function
INDBC( ) Function
INDEXSEEK( ) Function
INKEY( ) Function
INLIST( ) Function
INPUTBOX( ) Function
INSMODE( ) Function
INT( ) Function
ISALPHA( ) Function
ISBLANK( ) Function
ISCOLOR( ) Function
ISDIGIT( ) Function
ISEXCLUSIVE( ) Function
ISFLOCKED( ) Function
ISLEADBYTE( ) Function
ISLOWER( ) Function
ISMEMOFETCHED( ) Function
ISMOUSE( ) Function
ISNULL( ) Function
ISPEN( ) Function
ISREADONLY( ) Function
ISRLOCKED( ) Function
ISTRANSACTABLE( ) Function
ISUPPER( ) Function
JUSTDRIVE( ) Function
JUSTEXT( ) Function
JUSTFNAME( ) Function
JUSTPATH( ) Function
JUSTSTEM( ) Function
KEY( ) Function
KEYMATCH( ) Function
LASTKEY( ) Function
LEFT( ) Function
LEFTC( ) Function
LEN( ) Function
LENC( ) Function
LIKE( ) Function
LIKEC( ) Function
LINENO( ) Function
LOADPICTURE( ) Function
LOCFILE( ) Function
LOCK( ) Function
LOG( ) Function
LOG10( ) Function
LOOKUP( ) Function
LOWER( ) Function
LTRIM( ) Function
LUPDATE( ) Function
MAKETRANSACTABLE( ) Function
MAX( ) Function
MCOL( ) Function
MDX( ) Function
MDY( ) Function
MEMLINES( ) Function
MEMORY( ) Function
MENU( ) Function
MESSAGE( ) Function
MESSAGEBOX( ) Function
MIN( ) Function
MINUTE( ) Function
MLINE( ) Function
MOD( ) Function
MONTH( ) Function
MRKBAR( ) Function
MRKPAD( ) Function
MROW( ) Function
MTON( ) Function
MWINDOW( ) Function
NDX( ) Function
NEWOBJECT( ) Function
NORMALIZE( ) Function
NTOM( ) Function
NUMLOCK( ) Function
NVL( ) Function
OBJTOCLIENT( ) Function
OCCURS( ) Function
OLDVAL( ) Function
ON( ) Function
ORDER( ) Function
OS( ) Function
PAD( ) Function
PADL( ) | PADR( ) | PADC( ) Fu…
PARAMETERS( ) Function
PAYMENT( ) Function
PCOL( ) Function
PCOUNT( ) Function
PEMSTATUS( ) Function
PI( ) Function
POPUP( ) Function
PRIMARY( ) Function
PRINTSTATUS( ) Function
PRMBAR( ) Function
PRMPAD( ) Function
PROGRAM( ) Function
PROMPT( ) Function
PROPER( ) Function
PROW( ) Function
PRTINFO( ) Function
PUTFILE( ) Function
PV( ) Function
QUARTER( ) Function
RAISEEVENT( ) Function
RAND( ) Function
RAT( ) Function
RATC( ) Function
RATLINE( ) Function
RECCOUNT( ) Function
RECNO( ) Function
RECSIZE( ) Function
REFRESH( ) Function
RELATION( ) Function
REMOVEPROPERTY( ) Function
REPLICATE( ) Function
REQUERY( ) Function
RGB( ) Function
RGBSCHEME( ) Function
RIGHT( ) Function
RIGHTC( ) Function
RLOCK( ) Function
ROUND( ) Function
ROW( ) Function
RTOD( ) Function
RTRIM( ) Function
SAVEPICTURE( ) Function
SCHEME( ) Function
SCOLS( ) Function
SEC( ) Function
SECONDS( ) Function
SEEK( ) Function
SELECT( ) Function
SET( ) Function
SETFLDSTATE( ) Function
SETRESULTSET( ) Function
SIGN( ) Function
SIN( ) Function
SKPBAR( ) Function
SKPPAD( ) Function
SOUNDEX( ) Function
SPACE( ) Function
SQLCANCEL( ) Function
SQLCOLUMNS( ) Function
SQLCOMMIT( ) Function
SQLCONNECT( ) Function
SQLDISCONNECT( ) Function
SQLEXEC( ) Function
SQLGETPROP( ) Function
SQLIDLEDISCONNECT( ) Function
SQLMORERESULTS( ) Function
SQLPREPARE( ) Function
SQLROLLBACK( ) Function
SQLSETPROP( ) Function
SQLSTRINGCONNECT( ) Function
SQLTABLES( ) Function
SQRT( ) Function
SROWS( ) Function
STR( ) Function
STRCONV( ) Function
STREXTRACT( ) Function
STRTOFILE( ) Function
STRTRAN( ) Function
STUFF( ) Function
STUFFC( ) Function
SUBSTR( ) Function
SUBSTRC( ) Function
SYS( ) Functions Overview
SYSMETRIC( ) Function
TABLEREVERT( ) Function
TABLEUPDATE( ) Function
TAG( ) Function
TAGCOUNT( ) Function
TAGNO( ) Function
TAN( ) Function
TARGET( ) Function
TEXTMERGE( ) Function
TIME( ) Function
TRANSFORM( ) Function
TRIM( ) Function
TTOC( ) Function
TTOD( ) Function
TXNLEVEL( ) Function
TXTWIDTH( ) Function
TYPE( ) Function
UNBINDEVENTS( ) Function
UNIQUE( ) Function
UPPER( ) Function
USED( ) Function
VAL( ) Function
VARTYPE( ) Function
VERSION( ) Function
WBORDER( ) Function
WCHILD( ) Function
WCOLS( ) Function
WDOCKABLE( ) Function
WEEK( ) Function
WEXIST( ) Function
WFONT( ) Function
WLAST( ) Function
WLCOL( ) Function
WLROW( ) Function
WMAXIMUM( ) Function
WMINIMUM( ) Function
WONTOP( ) Function
WOUTPUT( ) Function
WPARENT( ) Function
WREAD( ) Function
WROWS( ) Function
WTITLE( ) Function
WVISIBLE( ) Function
XMLTOCURSOR( ) Function
XMLUPDATEGRAM( ) Function
YEAR( ) Function

Switch View :

ScriptFree

Visual FoxPro 9.0 SP2

RIGHT( ) Function

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


RIGHT(cExpression, nCharacters)

Parameters

cExpression: Specifies the character expression whose rightmost characters are returned.

nCharacters: Specifies the number of characters returned from the character expression. RIGHT( ) returns the entire character expression if nCharacters is greater than the length of cExpression. RIGHT( ) returns an empty string if nCharacters is negative or 0.

Return Value

Character

Remarks

Characters are returned beginning with the last character on the right and continuing for a specified number of characters.

Example

CLEAR
? RIGHT('Redmond, WA', 2)  && Displays WA

See Also

Reference

AT( ) Function
AT_C( ) Function
ATC( ) Function
ATCC( ) Function
ATCLINE( ) Function
ATLINE( ) Function
LEFT( ) Function
LEFTC( ) Function
LTRIM( ) Function
RAT( ) Function
RATLINE( ) Function
RTRIM( ) Function
RIGHTC( ) Function
SUBSTR( ) Function
SUBSTRC( ) Function
TRIM( ) Function

Other Resources

Functions