how ca i select the values of a column in one variable ?

• Alexandru Petre Ionescu

  SSC-Addicted

  Points: 443

  More actions

  May 12, 2006 at 3:29 am

  #112080

  hello friends (if i may call you friends even if i don't know you- i am also a begginer in this community) ...my name is Adrian and i need help ...in the folowing problem:

  i would like to select the values of a varchar colomn into one @variable without using the cursors...... if there is anybody who knows how i ask him(her) very nice to help me......

   

  regards from

  Adrian

• brij_rauthan

  SSCommitted

  Points: 1521

  More actions

  May 12, 2006 at 3:42 am

  #637477

  Hi Adrian

  Hope this helps:::

  Use Pubs

  Declare @TitleList Varchar(8000)

  SELECT @TitleList = COALESCE(@TitleList + ', ', '') + au_fname FROM Authors

  SELECT @TitleList

  Thanks

  Brij Rauthan

  Brij

• Alexandru Petre Ionescu

  SSC-Addicted

  Points: 443

  More actions

  May 12, 2006 at 3:49 am

  #637479

  Thanks a lot brij_rauthan ...it works