Concatenates two string values together.

Syntax

---

CONCAT(<StringExpression> WITH <StringExpression>)
CONCAT(<StringExpression>, <StringExpression>)

<StringExpression> = 

Type of:

CHARACTER|CHAR
CHARACTER VARYING|VARCHAR
GUID
CHARACTER LARGE OBJECT|CLOB

Returns

---

Same as first input

Usage

---

The CONCAT function concatenates two strings together and returns the concatenated result.

Examples

---

UPDATE Customers
SET notes = CONCAT(Notes WITH #13 + #10 + #13 + #10 + 'End of Notes')

SQL 2003 Standard Deviations

---

This function deviates from the SQL 2003 standard in the following ways: