How to add multiline text in varchar(MAX) field

Question

I have created varchar(MAX) field as memo field. Unfortunately I do not find a way how to add multiline text into such field using MS SQL Server Management Studio. If I use copy/paste of multiline text only first line of multiline test is inserted into varchar(MAX) field.

score 21 · Accepted Answer · answered Jul 29 '11 at 11:44

21

As you observe, if you paste in multi-line text only the first line is inserted, instead paste the text into an update statement and run that;

update T set fld =
'aaa
sss
ddd'
where ...

(You need to SELECT in results to text mode to observe the lines, in the grid view they appear as double-spaces)

answered Jul 29 '11 at 11:44

Alex K.

171,639
30
264
288

May i know how to select it as multiple rows – Sam1604 Jun 28 '14 at 06:40
Best to post a new question. – Alex K. Jun 28 '14 at 09:03

score 1 · Answer 2 · answered Jul 29 '11 at 11:34

1

You can use REPLACE('Line1@Line2@Line3', '@', CHAR(13) + CHAR(10)), for example.

answered Jul 29 '11 at 11:34

User

3,244
8
27
48

score 0 · Answer 3 · answered Jul 29 '11 at 11:32

0

did you try ALT+ENTER.. this should add a new line

answered Jul 29 '11 at 11:32

Anantha Sharma

9,920
4
33
35

All+Enter jums to next records. – Tomas Jul 29 '11 at 11:37

How to add multiline text in varchar(MAX) field

3 Answers3