SQL functions are CRM functions that can be used in summary pages. They translate into the respective database functions in order to be fully compatible.

Attributes

Name	Description	Example
SQL_ISNULL	If the field is null then it replaces its value.	SQL_ISNULL(FieldA, '')
SQL_UPPER	Converts lowercase letters to uppercase.	SQL_UPPER(CC.CONTACTFIRSTNAME)
SQL_+	String concatenation.	CUSTOMERS.CustName SQL_+ ' (' SQL_+ CUSTOMERS.CustNum SQL_+ ')'
SQL_GETDATETIME	Used to retrieve the current timestamp.	SQL_GETDATETIME
SQL_TOCHAR	Converts a field to a value of VARCHAR2 datatype.	SQL_TOCHAR(13)
SQL_SUBSTRING	Retrieves the substring of a string.	SQL_SUBSTRING(FirstName, 1, 1)
SQL_CONCAT	Concatenates a number of fields.	SQL_CONCAT[FieldA~FieldB~…~FieldN]
SQL_YEAR[ ]SQL_YEAR	Get the year of a date.	SQL_YEAR[SQL_GETDATETIME]SQL_YEAR
SQL_MONTH[ ]SQL_MONTH	Get the month of a date.	SQL_MONTH[EFFECTIVEDATE]SQL_MONTH
SQL_WEEK[ ]SQL_WEEK	Get the week of a date.	SQL_WEEK[UPDATEDDATE]SQL_WEEK
SQL_DAY[ ]SQL_DAY	Get the day of a date.	SQL_DAY[CREATEDDATE]SQL_DAY
SQL_NUMERAL[ ]SQL_NUMERAL	Gets the number of days of a date	SQL_NUMERAL[SQL_GETDATETIME]SQL_NUMERAL

Browser not supported