Can this be done in a User Defined Function?

• Isaac Kunz

  SSC Rookie

  Points: 30

  More actions

  September 21, 2004 at 9:24 am

  #163203

  declare @ordlist varchar(1000)

  select @ordlist = isnull(@ordlist + ', ','')  + OrderVal

  from viewOrders

  where Type=1 AND Status='A' AND rdNum=@selNum">OrdNum=@selNum

  select @ordlist AS ConcatOrd

  GO

  It Works in a Stored Procedure

• Goce Smilevski

  SSCommitted

  Points: 1704

  More actions

  September 22, 2004 at 1:27 am

  #523919

  Hi Isaac,

  it can be done:

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=99869

  Regards,

  Goce.