Tom B. wrote:
So, do you mean something like:
select group_concat(RefDes) as Clump
from MyTable
group by cast ((substr(RefDes, 2, 99) - 1) / 50 as integer)
Yes, something like that is just what I needed. Thanks!
(The designators are not always in such a monotonic sequence, nor is
their numerical part so predictable, but those issues can be met in the
source table design.)
Thanks, too, for helping me see that I should look at 'group by' clauses
more fundamentally.
Best regards,
--
Larry Brasfield
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
