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 |