Thanks, Simon. The database was created by a developer as part of a larger project involving a mobile app and portal. the portal is written in which calls the db. so that's where the 'parsing' is done. But unfortunately a SQL alone cannot provide the data in this case. This portal is in production so we're not about to rewrite the code with a db redesign.
Does SQL have any string commands, like REGEXP or something else to strip out the commas, and transform the string into multiple discrete values, then use those perhaps in a SQL subquery . or something like that? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
