I'm thinking it's parameters would be the name of a column and a character to designate where the string wold be separated. It would return multiple rows and each row would contain a piece of the string.
In other word, take a table like this: c1 c2 ------- 1 a; b; c run a statement like this: select c1, split(c2, ';')from t1; and get this: c1 c2 ------- 1 a 1 b 1 c Maybe SQLite can do it or not, i don't know. I've searched using Google and found code for a few different implementations but they are for other dialects of SQL. Here's a link to one such function i found: http://www.logiclabz.com/sql-server/split-function-in-sql-server-to-break-comma-separated-strings-into-table.aspx Would that work with SQLite? On Aug 24, 2011, at 8:40 PM, Igor Tandetnik wrote: > On 8/24/2011 9:36 PM, Gregory Moore wrote: >> Thanks for answering! Can this not be added as a function? > > What parameters would such a function take, and more interestingly, what > would its return value be? > -- > 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
