---
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
---
# 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.*