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.
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for