select strings from a table and return them as an array

[sftranna]

I would like to select strings from a table and return them as an array

For example,
select new_array(name) from my_tbl
would return

String[] { name1, name2, name3, etc }

Is this possible with built-in SQL/MSSql SERVER functions?

im Currently using SQL SERVER 2005

[Dijkgraaf]

Do a search for split MS SQL function and you will find various examples.