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 After much googling I'm thinking I need a split function. I know SQLite allows addition of functions. I did find a few different implementations of split functions, but there were from full SQL and SQL Server sites. Do I need a split function designed specifically for SQLite? How would I go about adding the function so I can use it? Thanks! Greg Moore thewatchful...@gmail.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users