EVALUATE( ) Function

  • Article

Evaluates a character expression and returns the result.

EVALUATE(cExpression)

Return Values

Character, Numeric, Currency, Date, DateTime, Logical, or Memo

Parameters

  • cExpression
    Specifies the expression to evaluate. cExpression can be a literal character string, or a valid Visual FoxPro expression, variable, array element, or field of any data type, enclosed in quotation marks. cExpression cannot exceed 255 characters.

    Whenever possible, use EVALUATE( ) or a name expression to replace macro substitution using &. EVALUATE and name expressions execute faster than macro substitution.

Remarks

EVALUATE( ) is similar to TYPE( ) but returns the result of an expression instead of the expression type. An expression containing EVALUATE( ) cannot be optimized by Rushmore.

Including the EVALUATE( ) function in the WHERE clause of a SQL query can return incorrect data.

See Also

TYPE( ) | _Evaluate( ) API Library Routine | Using Rushmore to Speed Data Access