select

Hello Guys/Gals

Would like to select 5 items from a table

ids
1
2
3
4
5

and concatenate them to return
1 2 3 4 5

any ideas? Could that be done in 1 select statement?

Thanks in advance...

This has been dealt with in the General Forum on this thread:

http://forums.vb-world.net/showthrea...hreadid=120810