New to NetSuite | SuiteQL: Syntax Requirements in Connect Service

In the New to NetSuite | SuiteQL Overview article, we explored the fundamental concepts and capabilities of SuiteQL. Now, we will focus on the essential syntax requirements that must be followed when writing SuiteQL queries, particularly when using the Connect Service. Understanding these rules will help ensure that your queries execute correctly and efficiently within NetSuite.

When writing queries using SuiteQL with the Connect Service, follow these important syntax rules to avoid errors:

String Concatenation

• The + operator cannot be used for concatenating strings.
• Instead, use the || operator for both field concatenation and literal concatenation.
• Example:

SELECT firstName || ' ' || lastName AS fullName FROM customer;