That's the way to go. The only thing you can do if you are using SQL 2000, is to create a UDF that will concatenate rows and return the concatenation as a varchar.


>I would like to return a concatenated string from a select statement rather than a series of records.
>
>I realise I can just return a table and then convert it into to string myself, but I wondered if there was a SQL Server way of doing this, that return the string as some sort of scalar value.
>
>at present I would have to do the following
>
>Select myfield from mytable
>
>mystring=''
>for i = 1 to reccount
> mstring = myfield + chr(13)
> move to next record
>next i
>
>
>I am trying to remove the code loop above
>
>Many Thanks