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