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, 5644🔥, 1💬
Popular Posts:
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and...
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measu...
How To Install PHP on Windows in MySQL? The best way to download and install PHP on Windows systems ...
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...