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 ?" This would mean concatenating the fields with a space between each field. I can do this programatically with a simple 'SELECT Field1 FROM TableA' and then cycling through the result and building a string, but I was curious if this is possible using only SQL. Thanks Greg _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
