| title | Scalar Function Escape Sequence | 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 |
|
|||
| ms.assetid | aaf5d516-e090-445f-8839-9e39581c69c7 | |||
| author | David-Engel | |||
| ms.author | v-daenge |
ODBC uses escape sequences for scalar functions. The syntax of this escape sequence is as follows:
{fn scalar-function}
In BNF notation, the syntax is as follows:
ODBC-scalar-function-escape ::=
ODBC-esc-initiator fn scalar-function ODBC-esc-terminator
scalar-function ::= function-name (argument-list)
(The definitions for the nonterminals function-name and function-name (argument-list) are derived from the list of scalar functions in Appendix E: Scalar Functions.)
ODBC-esc-initiator ::= {
ODBC-esc-terminator ::= }
To determine whether the data source supports procedures and the driver supports the ODBC procedure invocation syntax, an application can call SQLGetInfo. For more information, see Appendix E: Scalar Functions.