SQL Carriage Returns or Tabs in SQL Server strings - SQL Shack
https://www.sqlshack.com/sql-carriage-return-or-tab-in-sql-server-string/
We might require inserting a carriage return or line break while working with the string data. In SQL Server, we can use the CHAR function with ASCII number code. We can use the following ASCII codes in SQL Server: 1. Char(10)– New Line / Line Break 2. Char(13)– Carriage Return 3. Char(9)– Tab Let’s explore these ASCII codes with CHAR functions wit...
We might require inserting a carriage return or line break while working with the string data. In SQL Server, we can use the CHAR function with ASCII number code. We can use the following ASCII codes in SQL Server: 1. Char(10)– New Line / Line Break 2. Char(13)– Carriage Return 3. Char(9)– Tab Let’s explore these ASCII codes with CHAR functions wit...
DA: 13 PA: 47 MOZ Rank: 51