Set and scalar SQL functions

The KDB ODBC driver supports all the set functions and scalar numeric, string and date functions defined in Appendix F of the Microsoft ODBC 2.0 Programmers Reference.

The scalar functions can be invoked using the ODBC conventions for functions of { fn function() }. e.g.

SELECT {fn UCASE(NAME)} FROM CUSTOMERS

but the functions are also acceptible in inline SQL as in

SELECT UCASE(NAME) FROM CUSTOMERS

Set functions

String functions

Numeric functions

Date functions

System functions

Type conversion