Share via


Scalar Functions

The Microsoft ODBC Desktop Database Drivers support the following scalar functions:

CONCAT
CONVERT
CURDATE
CURTIME
DATABASE
DAYOFMONTH
DAYOFWEEK

LCASE
LEFT
LENGTH
LOCATE
LTRIM
MOD
MONTH

RIGHT
RTRIM
SUBSTRING
UCASE
USER
YEAR

For information about the arguments and return values of scalar functions, see Appendix F of the ODBC Programmer's Reference.