SQL Functions
SQL functions are CRM functions that are used in summary pages. They translate into their respective database compatible functions.
Attributes
| Name | Description |
|---|---|
| SQL_ISNULL | If the field is null then it replaces its value. |
SQL_UPPER | |
| SQL_+ | String concatenation. |
| SQL_GETDATETIME | Used to retrieve the current timestamp. |
SQL_TOCHAR | |
| SQL_SUBSTRING | Retrieves the substring of a string. |
| SQL_CONCAT | Concatenates a number of fields. |
| SQL_YEAR[ ]SQL_YEAR | Get the year of a date. |
| SQL_MONTH[ ]SQL_MONTH | Get the month of a date. |
| SQL_WEEK[ ]SQL_WEEK | Get the week of a date. |
| SQL_DAY[ ]SQL_DAY | Get the day of a date. |
| SQL_NUMERAL SQL_NUMERAL | Gets the number of days of a date |