SQLite does not have a built-in CONCAT()
function, however, it does have a concatenation operator (||
) that can be added between two strings to join them together. For example:
SELECT "Hello " || "World!" AS result;
This would result in the following:
+---------------+ | result | +---------------+ | Hello World! | +---------------+
Hope you found this post useful. It was published . Please show your love and support by sharing this post.