SQL Functions

|| (Concatenation)

The || function returns a single concatenated character string made up of two or more character strings. CHAR||CHAR will return a CHAR string; everything else will return a C STRING.

All blanks are preserved during concatenation. Use the TRIM function to eliminate blanks if desired.

Syntax

string || string[ || string[...]]

string

string can be a literal or reference column data

||

Required. The || (double vertical bars) is the concatenation character. It goes between two character strings to be concatenated together.

top

Example

select company,

CUSTOMERS.LASTNAME || ', ' || CUSTOMERS.FIRSTNAME

from customers
where company = 'systems'

OR

select

PRODUCTS.PRODUCT_NO || ' is the product number for ' || PRODUCTS.DESCRIPTION

from products

top