How to make a line feed?

Question

SQL Server

It is necessary that in the SMS every new phone number is displayed from a new line. I send SMS through sql server procedure. char(10) = Char(13) don't work. More precisely, they work only on SSMS.

Answer 1

SELECT CONVERT(VARCHAR, CAST( 'SMS' + CHAR(0x0D) + CHAR(0x0A) + 'SMS' AS binary), 2)

As you can see 534D53 0D0A 534D53everything works.
Try to read this value as a BLOB.