skip to main content
Reference : Supported SQL Statements and Extensions : SQL Expressions : Operators : Concatenation Operator
  

Try DataDirect Drivers Now
Concatenation Operator
The concatenation operator manipulates character strings. The following table lists the only supported concatenation operator.
Table 27. Concatenation Operator
Operator
Purpose
Example
||
Concatenates character strings.
SELECT 'Name is' || ename FROM emp
The result of concatenating two character strings is the data type VARCHAR.