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...