SQL String Concatenation

• Jesper-244176

  SSCertifiable

  Points: 7142

  More actions

  September 13, 2005 at 2:43 am

  #589272

  Agree on the first comment, but not on the second. Try this:

  Declare @Var as varchar(1000)

  set @Var = ''

  Select @Var = @Var + case when len(@Var) + len(name + ', ') < 1000 then name + ', ' else '' end

  from dbo.SysObjects order by name

  Select @Var, len(@Var)