SQL Functions

The RSSBus BizTalk Adapter for NetSuite provides functions that are similar to those that are available with most standard databases. These functions are implemented in the RSSBus provider engine and thus are available across all data sources with the same consistent API. Three categories of functions are available:

String Functions

These functions perform string manipulations and return a string value. See STRING Functions for more details.

SELECT CONCAT(firstname, space(4), lastname) FROM Account

Date Functions

These functions perform date and date time manipulations. See DATE Functions for more details.

SELECT CURRENT_TIMESTAMP() FROM Account

Math Functions

These functions provide mathematical operations. See MATH Functions for more details.

SELECT RAND() FROM Account

Function Parameters and Nesting SQL Functions

The adapter supports column names, constants, and results of other functions as parameters to functions. The following are all valid uses of SQL functions:

SELECT CONCAT('Mr.', SPACE(2), firstname, SPACE(4), lastname) FROM Account