Home Forums Article Discussions Article Discussions by Author Discuss content posted by Carl P. Anderson Concatenating Rows RE: Concatenating Rows

  • October 13, 2009 at 10:38 pm

    #1065491

    Perhaps something in your requirements precluded this method but how about this:

    DECLARE @var varchar(8000)

    SET @var = ''

    SELECT @var = @var + FieldName + '/'

    FROM Table

    SELECT @Var