homepage Welcome to WebmasterWorld Guest from 54.242.140.11
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
select strings from a table and return them as an array
sftranna



 
Msg#: 4188091 posted 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

WebmasterWorld Senior Member 5+ Year Member



 
Msg#: 4188091 posted 11:00 pm on Aug 17, 2010 (gmt 0)

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

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved