concat sqlite code example

Example 1: concat sqlite

SELECT
    FirstName || ' ' || LastName AS FullName
FROM
    Employees
ORDER BY
    FullName;

Example 2: concat sqlite

ad'||'min'||''-''-''||''