Welcome to WebmasterWorld Guest from 23.20.223.88

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)



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)

WebmasterWorld Senior Member 10+ Year Member



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

Featured Threads

Hot Threads This Week

Hot Threads This Month