MDAC 2.5 SDK - Visual FoxPro ODBC Driver
The following table describes ODBC numeric functions supported by the Visual FoxPro ODBC Driver; when the Visual FoxPro grammar for the same function differs from the ODBC syntax, the Visual FoxPro equivalent is listed.
| ODBC grammar | Visual FoxPro grammar |
| ABS (numeric_exp) | |
| ACOS (float_exp) | |
| ASIN (float_exp) | |
| ATAN (float_exp) | |
| ATAN2 (float_exp1, float_exp2) | ATN2 (float_exp1, float_exp2) |
| CEILING (numeric_exp) | |
| COS (float_exp) | |
| COT (float_exp) | |
| DEGREES (numeric_exp) | RTOD (numeric_exp) |
| EXP (float_exp) | |
| FLOOR (numeric_exp) | |
| LOG (float_exp) | |
| LOG10 (float_exp) | |
| MOD (integer_exp1, integer_exp2) | |
| PI ( ) | |
| RADIANS (numeric_exp) | DTOR (numeric_exp) |
| RAND ([integer_exp]) | |
| ROUND (numeric_exp, integer_exp) | |
| SIGN (numeric_exp) | |
| SIN (float_exp) | |
| SQRT (float_exp) | |
| TAN (float_exp) | |
The following numeric functions are not supported:
POWER (numeric_exp, integer_exp)
TRUNCATE (numeric_exp, integer_exp)