On Mon, Jun 9, 2008 at 3:49 PM, Bruce Robertson <[EMAIL PROTECTED]> wrote: >> select f || ' ' || group_concat(t, ' ') >> from w >> where f in (1, 2, 3); >> group by f; >> >> HTH >> Dennis > > Can you explain that? > > What's the || ' ' || part?
|| is the string concat operator. e.g.
SELECT "foo" || "bar";
will print:
foobar
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
