Functions

Article
06/18/2008

Visual FoxPro contains functions in the following categories as well as additional functions.

Character Functions
Lists functions that operate on character data.
Data Conversion Functions
Lists functions that convert data from one data type to another.
Date and Time Functions
Lists functions that generate and manipulate date and time data.
COM Functions
Lists the commands and functions that make it possible for you to access COM objects and servers.
Numeric Functions
Lists functions that operate on or return numeric data.
XML Functions
Describes functions that make it possible for data manipulations between Visual FoxPro and Extensible Markup Language (XML) data.
Supported Visual FoxPro Commands and Functions in OLE DB Provider
Lists commands and functions you can use in the OLE DB Provider.
Unsupported Visual FoxPro Commands and Functions in OLE DB Provider
Lists commands and functions not supported in the OLE DB Provider.

For information about backward compatible-only language reference, see Backward-Compatible Language Elements.

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_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

COL( ) 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

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

EVENTHANDLER( ) Function

EVL( ) 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

FUNCTION Command

FWRITE( ) Function

GETAUTOINCVALUE( ) Function

GETBAR( ) Function

GETCOLOR( ) Function

GETCP( ) 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

GETCURSORADAPTER( ) Function

GOMONTH( ) Function

HEADER( ) Function

HOME( ) Function

HOUR( ) Function

ICASE( ) Function

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

MDOWN( ) 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

OBJNUM( ) Function

OBJTOCLIENT( ) Function

OBJVAR( ) Function

OCCURS( ) Function

OEMTOANSI( ) Function

OLDVAL( ) Function

ORDER( ) Function

PAD( ) Function

PADL( ) | PADR( ) | PADC( ) Functions

PARAMETERS( ) Function

PAYMENT( ) Function

PCOL( ) Function

PCOUNT( ) Function

PEMSTATUS( ) Function

POPUP( ) Function

PRIMARY( ) Function

PRINTSTATUS( ) Function

PRMBAR( ) Function

PRMPAD( ) Function

PROGRAM( ) Function

PROMPT( ) Function

PROPER( ) Function

PROW( ) Function

PRTINFO( ) Function

PUTFILE( ) Function

QUARTER( ) Function

RAISEEVENT( ) Function

RAND( ) Function

RAT( ) Function

RATC( ) Function

RATLINE( ) Function

RDLEVEL( ) Function

READKEY( ) Function

RECCOUNT( ) Function

RECNO( ) Function

RECSIZE( ) Function

REFRESH( ) Function

RELATION( ) 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

UPDATED( ) Function

UPPER( ) Function

USED( ) Function

VAL( ) Function

VARREAD( ) 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

See Also

Other Resources

Language Reference (Visual FoxPro)