In our database we have 3 address lines. In Outlook there are only 2. This means we have to add two of the lines together in the view. The problem is with displaying this in Outlook as we need a line feed between character between our 2 address lines that has been added together in the SQL view. My issue is, that I do know what outlook uses as a line feed character. Is it possible for you to advise me on this.

Outlook uses the following new line characters:
Line Feed
Values:Oct=12, Dec=10, Hex=a

Carriage Return
Values:Oct=15, Dec=13, Hex=d

Please note:
Exact formatting of full (Street,Zip etc...)Address can differ per Outlook version etc..