Thanks for answering! Can this not be added as a function? On Aug 22, 2011, at 10:43 PM, Igor Tandetnik wrote:
> Gregory Moore <thewatchful...@gmail.com> wrote: >> I need to split up a list of items in a single row so they each have >> their own row. >> >> Basically I need to take this: >> >> Key. Code >> -------------- >> 1. V1, v2, v3 >> >> And convert it to this: >> >> Key. Code >> -------------- >> 1. V1 >> 1. V2 >> 1. V3 > > I don't think you can do this with SQL alone. You'll have to implement the > logic in your favorite programming language. > -- > Igor Tandetnik > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users Gregory Moore thewatchful...@gmail.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users