The table identifies the scalar functions that Hybrid Data Pipeline supports for Microsoft Dynamics.

Applications connecting through JDBC or ODBC can use the following scalar functions in expressions. For syntax details, consult your JDBC or ODBC documentation.

String Functions | Numeric Functions | Timedate Functions | System Functions |

ASCII | ABS | CURDATE | CURSESSIONID |

BIT_LENGTH | ACOS | CURTIME | DATABASE |

CHAR | ASIN | DATEDIFF | IDENTITY |

CHAR_LENGTH | ATAN | DAY | USER |

CHARACTER_LENGTH | ATAN2 | DAYNAME | IFNULL |

CONCAT | CEILING | DAYOFMONTH | |

DIFFERENCE | BITAND | DAYOFWEEK | |

HEXTORAW | BITOR | DAYOFYEAR | |

INSERT | BITXOR | EXTRACT | |

LCASE | COS | HOUR | |

LEFT | COT | MINUTE | |

LENGTH | DEGREES | MONTH | |

LOCATE | EXP | MONTHNAME | |

LOCATE_2 | FLOOR | NOW | |

LOWER | LOG | SECOND | |

LTRIM | LOG10 | TO_CHAR | |

OCTET_LENGTH | MOD | WEEK | |

RAWTOHEX | PI | YEAR | |

REPEAT | POWER | ||

REPLACE | RADIANS | ||

RIGHT | RAND | ||

RTRIM | ROUND | ||

SOUNDEX | SIGN | ||

SPACE | SIN | ||

SUBSTR | SQRT | ||

SUBSTRING | TAN | ||

UCASE | TRUNCATE | ||

UPPER | ROUNDMAGIC |