SQLite Forum

How to cancatenate all lines in table to a single string?
Login
Hello,

Let's say we have table with variable number of rows containing text -

    sqlite> create table tab1(line);
    sqlite> insert into tab1 select 'text 1';
    sqlite> insert into tab1 select 'text 2';
    sqlite> insert into tab1 select 'text 3';
    ...

How can I select the following result `text 1 text 2 text 3 ...`?

-Shane