Question

Query to insert SQL carriage return and line break in query? Below query will helps you to insert carriage return or line break while working with the string data. We use CHAR function ASCII number code to get line break and carriage return

(1)Char(10) – New Line / Line Break

(2)Char(13) – Carriage Return

(3)Char(9) – Tab

Answer 1

To use above first we need to do below settings (1)Inserting line break or new line by use char(10) (2)Inserting SQL Carriage return by use char(13) (3)Inserting tab by use char(9)