Greg Robertson <[email protected]> wrote: > Is it possible with just an SQL to Concatenate the content from > several records of a single field with perhaps a character inbetween? > > For example if I have TableA that has Field1 with the following info > in Field1: > > rec1: How > rec2: are > rec3: you > rec4: ? > > Would it be possibly using only SQL to output a single field with the > content" "How are you ?"
select group_concat(Field1, ' ') from TableA; http://www.sqlite.org/lang_aggfunc.html Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
