CONCAT()
function is used to concatenate one or more input values into a single result. It supports all data types in Oxla, except TIMESTAMPTZ
, and the output will be returned as a concatenation of the input values.
Special cases: Returns NULL
if there are no input rows or NULL
values.
CONCAT()
functionCONCAT()
function to concatenate three values = into a single result:
CONCAT()
function using columncustFirstName
and custLastName
columns of the payment table:
CONCAT()
function in the following example to concatenate a string with a NULL
value:
CONCAT
function will skip the NULL
value: