VARTYPE( ) Function

Returns the data type of an expression.

VARTYPE(eExpression [, lNullDataType])

Return Values

Character

Parameters

• eExpression
  Specifies the expression for which the data type is returned. VARTYPE( ) returns a single character indicating the data type of the expression. The following table lists the characters that VARTYPE( ) returns for each data type:

  Character returned	Data type
  C	Character or Memo
  N	Numeric, Integer, Float, or Double
  Y	Currency
  L	Logical
  O	Object
  G	General
  D	Date
  T	DateTime
  X	Null
  U	Unknown

Note   If eExpression is an array, the first element in the array is evaluated.

• lNullDataType
  Specifies if VARTYPE( ) returns the data type when eExpression contains the null value. If lNullDataType is true (.T.), VARTYPE( ) returns the data type of eExpression. If lNullDataType is false (.F.) or omitted, VARTYPE( ) returns 'X', indicating that eExpression contains the null value.

Remarks

VARTYPE( ) is similar to the TYPE( ) function, but VARTYPE( ) is faster and does not require quotation marks to enclose the expression for which the data type is returned.

VARTYPE( ) returns "U" if you specify a variable that doesn't exist.

See Also

EVALUATE( ) | TYPE( ) | Data Types