Inserting Newline Character into Word

[SweetDot]

Hi all,

I have a function in SQL that stores a string that will be inserted into Word during mail merge. I would like to add a newline character into that function in SQL so that when it gets inserted during mail merge MS word will recognize the character. I have tried using CHAR(13) + 'xxxxx' in the SQL function, but it only shows up in MS word as square blocks. I hope my question is making sense. Can someone please help?

Thanks in advance

 

[PHV]

And this ?
Char(13) + Char(10) + 'xxxxx'

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886