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

Reply via email to