The following lists the Visual Basic ODBC scalar functions and their ANSI equivalents.
| VBA | ANSI | Description |
|---|---|---|
| & | Concat | concatenate two strings |
| \ | integer division | |
| ^ | Power | exponentiation |
| Abs | Abs | absolute value |
| And | bitwise and | |
| Asc | Ascii | converts a single char to an ASCII numeric value |
| Atn | Atan | arc tangent of angle |
| CBool | converts to boolean value | |
| CCur | converts to currency value | |
| CDate | converts to date-time value | |
| CDbl | converts to double precision value | |
| Chr | Char | converts an ASCII numeric value to a single char |
| CInt | converts to signed short integer value | |
| CLng | converts to signed long integer value | |
| Cos | Cos | cosine of angle |
| CSng | converts to single precision value | |
| CStr | converts to string | |
| CVar | converts to variant | |
| CVDate | converts to variant, subtype date | |
| Date | Current_Date | current date |
| DatePart | extract part of a date | |
| DateSerial | converts a date to a numeric value | |
| DateValue | converts a numeric value to a date | |
| Day | DayOfMonth | numeric day of month |
| Exp | Exp | natural exponentiation |
| Fix | truncate towards zero | |
| Format | generic formatter | |
| Hex | converts to string using base 16 | |
| Hour | Hour | numeric hour of day |
| IIf | two pronged conditional | |
| InStr | Locate | searches for a substring |
| Int | Floor | greatest integer less than or equal |
| IsDate | returns true for valid date values | |
| IsNull | returns true for null values | |
| IsNumeric | returns true for numeric values | |
| LCase | LCase | lowercase string |
| Left | Left | substring from left side of a string |
| Len | Char_Length | length in characters of string |
| Log | Log | natural logarithm |
| LTrim | LTrim | trims whitespace from left side of string |
| Mid | SubString | middle part of string extraction |
| Minute | Minute | numeric minute of hour |
| Mod | Mod | modulo of x base y |
| Month | Month | numeric month value |
| Not | bitwise one's complement | |
| Now | Current_Timestamp | current date and time |
| Oct | converts to string using base 8 | |
| Or | bitwise (inclusive) or | |
| RGB | converts separate R, G, B to a color value | |
| Right | Right | substring from right part of string |
| Rnd | Rand | random value |
| Round | Round | round to an integer value |
| RTrim | RTrim | trims whitespace from right side of string |
| Second | Second | numeric second value |
| Sgn | Sign | arithmetic sign of value |
| Sin | Sin | sine |
| Space | Space | generate n spaces |
| Sqr | Sqrt | square root |
| Str | converts a numeric values to a string | |
| StrComp | compares two strings | |
| String | Repeat | generates n repeated characters |
| Switch | multiple condition/values conditional | |
| Tan | Tan | tangent of angle |
| Time | Current_Time | current time |
| TimeSerial | converts a time to a numeric value | |
| TimeValue | converts a numeric value to a time | |
| Trim | trims whitespace of string | |
| UCase | UCase | uppercase string |
| Val | converts a string to a numeric value | |
| Weekday | DayOfWeek | numeric day of week |
| Xor | bitwise exclusive or | |
| Year | Year | numeric year value |