On 8 Mar 2017, at 2:33pm, Dominique Devienne <ddevie...@gmail.com> wrote:
> Same constraints of the "thousand separator" one, this will be a view in a > DB to be viewed by any SQLite client, so not allowed here. --DD In that case, I think Hick’s solution is good. Do it in two steps: construct a temporary table which includes the ranges (presumably using CASE), then interrogate that table. (Then presumably drop that table.) Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users