| title |
Scalar Functions | Microsoft Docs |
| ms.custom |
|
| ms.date |
01/19/2017 |
| ms.prod |
sql |
| ms.prod_service |
connectivity |
| ms.reviewer |
|
| ms.technology |
connectivity |
| ms.topic |
conceptual |
| helpviewer_keywords |
ODBC desktop database drivers [ODBC], scalar functions |
desktop database drivers [ODBC], scalar functions |
scalar functions [ODBC], desktop database drivers |
SQL grammar [ODBC], scalar functions |
|
| ms.assetid |
18e1e0c1-b43f-44d9-b310-7d9e1d499e8b |
| author |
David-Engel |
| ms.author |
v-daenge |
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.