List of SQL Functions

NetSuite offers a comprehensive suite of SQL Functions, catering to various data manipulation and analysis needs. Here’s a list of some of the common functions used:

Note: The links to the function explanations will be updated as new articles about SQL Functions are posted.

Numeric Functions

• ABS
• ROUND
• FLOOR
• CEIL
• MOD
• REMAINDER
• MOD vs. REMAINDER

Character Functions

• CONCAT
• LOWER & UPPER
• LPAD & RPAD
• TRIM, LTRIM & RTRIM
• REPLACE
• SUBSTR
• INSTR
• LENGTH
• Regular ExpressionsREGEXP_REPLACE
• REGEXP_SUBSTR
• REGEXP_INSTR
• TO_NUMBER()

Datetime Functions

• ADD_MONTHS
• LAST_DAY
• MONTHS_BETWEEN
• NEXT_DAY
• TRUNC(DATE)
• TO_CHAR()
• TO_DATE()
• TO_CHAR() vs. TO_DATE()

NULL-Related Functions

• NULLIF
• NVL
• NVL2
• COALESCE
• NVL vs COALESCE

Case, Decode, and Sysdate Functions

• SYSDATE
• CASEIN
• LIKEUsing Wildcards
• AND
• OR
• DECODE
• CASE vs DECODE

Analytic and Aggregate Functions

• DENSE_RANK
• KEEP()
• RANK

Note: For a complete list of SQL Expressions, visit SuiteAnswers 10101.

Learning SQL Functions is a valuable investment for any NetSuite user. It empowers you to take control of your data analysis, providing the skills to create dynamic reports and derive meaningful insights. With NetSuite’s extensive function library, you can explore countless ways to enhance your business intelligence.