Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Returns the data type of an expression.
Note
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(eExpression [, lNullDataType])
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.
Return value Data type C
Character, Memo, Varchar, Varchar (Binary)
D
Date
G
General
L
Logical
N
Numeric, Float, Double, or Integer
O
Object
Q
Blob, Varbinary
T
DateTime
U
Unknown or variable does not exist
X
Null
Y
Currency
Note
If eExpression is an array, the first element in the array is evaluated.
lNullDataType
Specifies whether VARTYPE( ) returns the data type when eExpression contains the null value.The following table lists the values of lNullDataType.
lNullDataType Description True (.T.)
Return data type for eExpression.
False (.F.) or omitted
Return 'X' to indicate eExpression contains a null value.
Character. VARTYPE( ) returns a character representing the data type of the specified expression.
EVALUATE( ) Function
TYPE( ) Function
Data and Field Types
Functions
Language Reference (Visual FoxPro)