| select strings from a table and return them as an array
|
sftranna
msg:4188093 | 4:05 am on Aug 17, 2010 (gmt 0) |
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
msg:4188418 | 11:00 pm on Aug 17, 2010 (gmt 0) |
Do a search for split MS SQL function and you will find various examples.
|
|
|
