I found a workaround.:-)

Now I use a group by statement and define the individual records as separate columns. Now I can use seperate mailmerge fields to get my data (per...

@craig-2 Farrell Okay, thank you for your help.

@craig-2 Farrell Thanks for your quick response!

I have tried this as a test:

select 'a'+ CHAR(10) + CHAR(13) +'b'+CHAR(10) + CHAR(13)+ ' c'+CHAR(10) + CHAR(13) as test

I also tried...

@craig-2 Farrell I need this fixed in SQL because I am using a Microsoft Word Merge field to display the data in a Word file.

This Word Merge fields presents the...

@LutzM Thanks for your reply

I have tested your suggestion and this gives me the output:

a b c

However I wanted the output to be:

a

b

c