Welcome to WebmasterWorld Guest from 54.227.110.209

Forum Moderators: open

Message Too Old, No Replies

select strings from a table and return them as an array

     

sftranna

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

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