Creating mailing label using database

Hi!

I have these tables:

DB1
MID
IIN
Title
FullName
Address
Apt
City
Province
PostalCode

DB2
MID
Lang
Version

How can I output a text file formatted like the one below?

(05) 01046 (F 05)
Mr. Sylvain Cote
123 Sesame Street
Apt 6
Charny, BC
L8T 5G6

where
(05)-MID
01046-IIN
(F 05) - LangConcatenate the various address components, separated by carriage return characters.|||Could you please post a sample code?

Thanks.|||select Title + ' ' + FullName + char(13)
+ Address + Char(13)
+ 'Apt ' + Apt + char(13)
+ City + ', ' + Province + char(13)
+ PostalCode + Char(13)
from YourTable