Home Forums SQL Server 7,2000 T-SQL Select multiple rows for column into single row, w/hard return RE: Select multiple rows for column into single row, w/hard return

  • October 30, 2014 at 8:55 am

    #1755808

    Total noob with all of the replies, apologies.

    Final obstacle, perhaps: I am trying to figure out how to strip/replace the extra (CHAR(10) + CHAR(13)) which precedes each list of values?

    In the example within the link you provided, a comma was placed before each value, then removed with the STUFF function. Handy, but I'm guessing this won't work with the CHAR(10) etc.