OwnerID, AString, Sequence 1, 'concatenate', 0 1, 'some', 1 1, 'strings', 2 1, 'together', 3
What I need to do is create a single string out of the AString, Sequence pairs, for a given owner. Obviously I could do this through some C++ code, but I would prefer to do it within SQL code, but can't think of a way. The sequences are not always the same lenght, i.e., a particular owner may have 1, 10, or 1972 word long sequences. With cursors, I don't think this would be difficult, but I can't figure out how to do this within SQLite.
Mike Chirico's tutorial (<http://voxel.dl.sourceforge.net/sourceforge/souptonuts/README_sqlite_tutorial.html>) might be helpful; it looks like what you want to do is conceptually similar to creating the "pivot tables" he describes.
