Scalar Functions
The Microsoft ODBC Desktop Database Drivers support the following scalar functions:
|
CONCAT |
LCASE |
RIGHT |
|
CONVERT |
LEFT |
RTRIM |
|
CURDATE |
LENGTH |
SUBSTRING |
|
CURTIME |
LOCATE |
UCASE |
|
DATABASE |
LTRIM |
USER |
|
DAYOFMONTH |
MOD |
YEAR |
|
DAYOFWEEK |
MONTH |
|
For information about the arguments and return values of scalar functions, see Appendix F of the ODBC Programmer's Reference.