Home
Compass SQL Reference
String functions
String functions
This section describes the string functions that are supported.
Side TOC
Side TOC
Compass SQL Reference
Query structure
Expressions and comparison functions
Logical and comparison operators
String functions
CHAR
CHARINDEX
CONCAT
CONCATENATION USING ||
INSTR
LEFT
LEN
LENGTH
LPAD
LOWER
LTRIM
REPLACE
RIGHT
RPAD
RTRIM
SUBSTR
SUBSTRING
TRIM
UPPER
Mathematical operators
Mathematical functions
Aggregation functions
Datetime functions
Conversion functions
Analytic functions
Views