Dear Nicholas,

I hope following will be help full for you.
------------------------------------------------
Declare @varstr as varchar(4000) -- declreation of
set @varstr = ''; --initializing you know the fact Null + somhting =
Null
select @varstr = @varstr+','+isnull(ProductName,',') from Product;
Select @varstr;
------------------------------------------------

Best of Luck

Saghir Taj
MCDBA
www.dbnest.com: Home of DB Professionals.

ngadacz@ftresearch.com wrote:
> hello,
>
> i would like to loop through a record set and assign each value to
the
> same string, (example i would like to return all of the first name in
> the authors table = Authors_total.)
>
> should i use a cursor or just a loop to do this? I have had some
> trouble with the syntax in a cursor.
>
> nicholas.gadacz