On Tue, Aug 23, 2011 at 7:10 AM, 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. >
You can read about my trick query solving partly this task with a trick http://www.mail-archive.com/sqlite-users@sqlite.org/msg55935.html This will require a user function (GetItemFromSet) and the results are limited in a sense. You will get ti idea from the following query (the version modified by Jim Morris) SELECT Trim(GetItemFromSet(Value, '23, 14, 1, 7, 9')) Item FROM SELECT B1.B + B2.B + B3.B + B4.B FROM (SELECT 0 AS B UNION SELECT 1 AS B) AS B1, (SELECT 0 AS B UNION SELECT 2 AS B) AS B2, (SELECT 0 AS B UNION SELECT 4 AS B) AS B3, (SELECT 0 AS B UNION SELECT 8 AS B) AS B4 ) WHERE NOT (Item Is Null) Also theoretically it is possible to use virtual tables for this. So when your virtual query implementation accepts list in some way ('23, 14, 1, 7, 9') and returns the table when querying Max _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
