Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in SQL by (20.3k points)

I didn't see any similar questions asked on this topic, and I had to research this for something I'm working on right now. Thought I would post the answer for it in case anyone else had the same question.

1 Answer

0 votes
by (40.4k points)

char(13)  is CR(Carriage Return) . 

For DOS-/Windows-style CRLF linebreaks, you need to use char(13)+char(10), like this:

'This is line 1.' + CHAR(13)+CHAR(10) + 'This is line 2.'

Related questions

0 votes
1 answer
0 votes
1 answer
Welcome to Intellipaat Community. Get your technical queries answered by top developers!

28.4k questions

29.7k answers

500 comments

94k users

Browse Categories

...