MDAC 2.5 SDK - ODBC Desktop Database Drivers
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.