SQL · String functions

concat_ws()

Joins values, skipping NULLs. SQLite 3.44+ and PostgreSQL.

sqlRunnable example sql course

Syntax

concat_ws(separator, …values)

Example

Open in the lab

SELECT concat_ws('-', '2026', '11', '01') AS date_parts;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.