On 8/24/2011 9:05 PM, Gregory Moore wrote: > 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 >> >> >> Gregory Moore >> thewatchful...@gmail.com >> lurker here, but felt compelled, and my apologies in advance, but ....
Isn't this more a function of whatever language you are using and not a SQLite issue? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users