SQL to return certain number of a column values concat to each other?

From: <adamvt_at_my-deja.com>
Date: Fri, 22 Sep 2000 20:14:44 GMT
Message-ID: <8qgej1$o5k$1@nnrp1.deja.com>

I wonder if this is possible with SQL? Say I have a table and if I SELECT column of it I get:

SELECT a_col FROM a_tab;

a_col

---

10
5160
129
230
515
4000
2398
456
239
.
.

And now I wanna create a view based on this table where I'll be able to get something like:

SELECT a_conc_col FROM a_view;

a_conc_col

---

10 5160 129
230 515 4000
2398 456 239
.
.

which concats every three values together. Is this possible? if so could you provide an example?
Thanks in advance!
Adam Tadj

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Sep 22 2000 - 15:14:44 CDT