concat function error

(1) By JKPalmer (jkpalmer) on 2025-02-26 13:02:32 [link] [source]

I am new to SQLite, but not with sql in general.

Using DB Browser application - so probably should post this on that website, but thought I'd ask here since it's easier to post issues / questions about functions.

I've been trying to use the concat function and looked it up on this website and it should be present, but using the statement below:

SELECT concat('SQLite', ' Concat') result;

Execution finished with errors.
Result: no such function: concat
At line 1:
SELECT concat('SQLite', ' Concat') result;

Help appreciated

-jP

(2) By Richard Hipp (drh) on 2025-02-26 13:19:33 in reply to 1 [source]

The concat() and concat_ws() compatibility functions where added to SQLite with version 3.44.0 (2023-11-01). Probably you are using an older version of SQLite.

(3) By JKPalmer (jkpalmer) on 2025-02-26 14:51:00 in reply to 2 [link] [source]

How do I determine what version of SQLite is being used by DB Browser for MacOS?

(4) By Richard Hipp (drh) on 2025-02-26 14:55:18 in reply to 3 [link] [source]

SELECT sqlite_source_id();