SQL Reference Guide > SQL Reference Guide > Understanding the Elements of SQL Statements > SQL Operations > String Concatenation Operations
Was this helpful?
String Concatenation Operations
To concatenate strings, use either the operator + or ||.
For example:
'This ' + 'is ' + 'a ' + 'test.'
gives the value:
'This is a test.'
Likewise:
'Hello ' || 'World'
gives the value:
'Hello World'
Also, the concat function can be used to concatenate strings. For details, see String Functions.
Last modified date: 04/03/2024