Breakline in Raiseerror

Question

is there anyway to breakline and continue on next line in RaiseError? <br/> and /n aren't working

Below is my code:

BEGIN
BEGIN TRY
    SELECT 16/0
END TRY
BEGIN CATCH
    WHILE(@Count != 0)
    BEGIN
        SET @MaterialName = (SELECT Material FROM #T WHERE Quantity = 0 AND ID = @Count)
        SET @MSG = 'Material %s was not offered.' 
        RAISERROR(@MSG,16,1,@MaterialName);
        SET @Count = @Count - 1
    END
END CATCH
END

I dont want to make changes in the data access layer, we only support web, not window app. I want each loop msg to be printed on next line using sql only. Is it possible?

Answer 1

if you include the line break in the text it will work.

SET @MSG = 'Material %s was not offered.
' 

Note that the end quote is on a new line.