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
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)
which seems to work.
Tom
Tom Brodhurst-Hill
BareFeetWare
--
iPhone/iPad/iPod and Mac software development, specialising in databases
I've got a table which can be described as holding one "RefDes" per
row. (They are reference designators in a electronic PCB schematic or
its bill-of-materials.) There are thousands of them, and each one is
very short, inducing the convention of clumping them together for
display in a
3 matches
Mail list logo
