Welcome to WebmasterWorld Guest from 23.20.184.141

Forum Moderators: open

Message Too Old, No Replies

select strings from a table and return them as an array

     
4:05 am on Aug 17, 2010 (gmt 0)

New User

5+ Year Member

joined:Aug 16, 2010
posts: 1
votes: 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
11:00 pm on Aug 17, 2010 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:May 31, 2005
posts:1108
votes: 0


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