On Mon, Sep 12, 2011 at 12:28 PM, Jean-Denis MUYS <jdm...@kleegroup.com> wrote: > > My question is: is there a pure SQL way to split the instances string, and > generate the instance lines from the instance list string? contrived example: >
This kind of questions appear from time to time (including my brain :) and there are tricky solutions like for example using specially implemented virtual tables (read my recent post here: http://www.mail-archive.com/sqlite-users@sqlite.org/msg63453.html) Thanks to your example I added delimiter support in the virtual table initialization and tested the concept on a real data, seems like it works. The query in this case looks like this SELECT TestTable.Id, TestTable.Name, cmlist.value FROM TestTable LEFT JOIN cmlist On Instances=commalist For those who familiar with sqlite virtual tables implementation this concept is probably an hour to implement. If you're on windows and ready to test your conversion with my tool, consider writing to me directly Max _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users