Collections:
Inserting New Line Characters into Strings in SQL Server
How To Insert New Line Characters into Strings in SQL Server Transact-SQL?
✍: FYIcenter.com
If you want to break a string into multiple lines, you need to insert new line characters into the string. With some client tools like SQL Server Management Studio, it is not so easy to insert a new line character.
One work around is to use the CHAR(int) function to generated new line character and other special characters with their code values:
The tutorial examples below gives you a good example
PRINT 'Welcome to '+CHAR(10)+'FYIcenter.com'; PRINT CHAR(10); PRINT 'Current date and time is ' +CONVERT(VARCHAR(20), GETDATE()); GO Welcome to FYIcenter.com Current date and time is May 19 2007 7:30PM
⇒ CHARINDEX() and SUBSTRING() - Locating and Taking Substrings in SQL Server
⇐ Character String Functions Supported by SQL Server 2005 in SQL Server
⇑ Character Strings and Binary Strings in SQL Server Transact-SQL
2022-05-12, 5922🔥, 1💬
Popular Posts:
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line In...
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? H...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...