[SQL] CONCAT Function in SQLite : Error - SQL Error [1]: [SQLITE_ERROR] SQL error or missing...

I am trying to CONCAT the DATA FROM my EMPLOYEE TABLE

TABLE EMPLOYEE
==============================================
empno ename Job salary deptno
----------------------------------------------
101 Roy Programmer 5000 20
102 Todd Analyst 6000 10
105 Leslie Analyst 5500 20
107 Cindy Developer 7200 30


with these queries

SELECT CONCAT(ename || 'is getting paid' || salary || 'for' || job)
FROM EMPLOYEES
WHERE empno = 101;
-- and
SELECT CONCAT(ename, 'is getting paid', salary, 'for', job)
FROM EMPLOYEES
WHERE empno = 101;


But both result in the error:

SQL Error [1]: [SQLITE_ERROR] SQL error or missing database (no such function: CONCAT)'
​

Expected Output:

"Roy is getting paid 5000 for Programmer"
​

Please assist!

Continue reading...