CONCAT_
Concatenates two or more strings or columns with a specified separator.
This function corresponds to the concat_ws(S, X, Y, ...) function in SQLite. The first argument is the separator, which is used between each of the subsequent arguments. Any NULL arguments among the strings to be concatenated are ignored.
Example
// SELECT concat_ws('-', 'a', 'b', 'c') -> 'a-b-c'
// SELECT concat_ws('-', col1, col2, col3) FROM MyTable
val cursor = select(CONCAT_WS("-", MyTable.col1, MyTable.col2, MyTable.col3)).from(MyTable)Content copied to clipboard
Return
A new KQLiteColumn of type String representing the concatenated result. The result is NULL if the separator is NULL.
Author
MOHAMMAD AZIM ANSARI
Parameters
separator
The string to use as a separator between concatenated values.
columns
Columns or values to concatenate.