Skip to content

Glossary: SQL Basics

Concatenation (||)

Also written: concatenate, ||, CONCAT

Joining text end to end with the `||` operator, for example `'Hi ' || 'Dana'`. Joining anything to NULL gives NULL; MySQL and SQL Server use CONCAT instead.

Where the book teaches it

Related terms

StringNULLOperator