Home Forums Article Discussions Article Discussions by Author Discuss content posted by Luis Costa get all values separated by commas RE: get all values separated by commas

  • July 19, 2012 at 7:17 am

    #1514827

    stuff((select ',' + ID

    from teste

    for XML path(''),TYPE).value('(./text())[1]','NVARCHAR(MAX)'

    ),

    1,

    1,

    '')

    This copes with any string length.