FunctionsString

concat_ws

Uses the first argument as separator, then concatenates non-NULL remaining arguments per row.

concat_ws(…) → String

Kind · scalar

Uses the first argument as separator, then concatenates non-NULL remaining arguments per row.

Part of the String family.

concat

Concatenates all provided arguments per row. NULL arguments are ignored; numeric arguments are stringified.

ends_with

Returns true when the first argument ends with the second argument for each row.