put all rows into a string

[eddie wang]

I have a column called state with 50 rows as 50 US states. I want to
display the rows as one string like TX, NY, ...

How can I do this easily? Thanks.

 

[Aaron Bertrand [MVP]]

Take a look at the GetString() function.

 

[Ray at]

Take a look at the .GetString method of the recordset object. sStates =
rs.GetString(2,,,","), I believe it could be.


http://www.aspfaq.com/2467
http://www.aspfaq.com/5007

Ray at work