Functions

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

COM Functions

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

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

FV( ) Function

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

ON( ) Function

ORDER( ) Function

OS( ) Function

PAD( ) Function

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

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

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)