Cinchy Supported Functions covers the following topics:

Scalar Functions

Cinchy functions and Cinchy User defined functions are used in conjunction with Cinchy DML and DDL statements. Cinchy System Values are specific to the Cinchy platform similar to Cinchy functions. Cinchy User Defined Functions are split into Table-Valued Functions and Scalar-valued functions.

**Scalar functions** operate on a single value and return a single value. Scalar functions are composed of:

Function Category | Description |

Support data type casting and converting | |

Perform operations on a date/time input values and return string, numeric, or date and time values | |

Logical | Perform logical operations |

Perform calculations based on input values provided as parameters to the functions, and return numeric values | |

String | Perform operations on a string ( |