Igor, that is a most oblique and intriguing approach. I will try it out and try to get my head around it in the next day or so.
Thanks, Tom Igor Tandetnik-2 wrote > On 10/16/2014 12:03 PM, Tom Holden wrote: >> I need a way to convert the text result to an expression that WHERE >> evaluates as an expression. >> >> Any possibility to do this within SQLite? > > with recursive split(str, tail) as ( > select null, 'string1+string2+string3' > union all > select substr(tail, 1, instr(tail || '+', '+')-1), substr(tail, > instr(tail || '+', '+') + 1) > from split where tail != '' > ) > select * from mytable where not exists ( > select str from split > where str is not null and value not like '%' || str || '%' > ); > > -- > Igor Tandetnik > > _______________________________________________ > sqlite-users mailing list > sqlite-users@ > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- View this message in context: http://sqlite.1065341.n5.nabble.com/WHERE-expression-with-operators-from-text-functions-tp78653p78697.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
