Home Forums SQL Server 2005 Development Need to merge multiple rows into one with carriage return RE: Need to merge multiple rows into one with carriage return

  • November 8, 2010 at 2:15 pm

    #1247899

    Use CHAR(13)

    so something like this..

    DECLARE @STR varchar(50)

    SELECT @STR = 'I'+CHAR(13)+'LOVE'+CHAR(13)+'SQL SERVER'

    PRINT @STR