Try OpenEdge Now
skip to main content
SQL Reference
SQL Reference : OpenEdge SQL Language Elements : Data types : Character data types : Concatenation operator
 
Concatenation operator
Use the concatenation operator (||) to join two text strings together.
The following example provides an example of a concatenation operator used in a query:

Example

SELECT firstname || ' ' || lastname from Employee;