I think this is what you need to do: Assuming your table is called MyTable and your new column would be called NewColumn, try
Alter Table "MyTable" ( add NewColumn Char(40) ) Interactive Update MyTable Set NewColumn = streetnames+streetnumbers Note that your street numbers should be text; if not, use this line before the other two: Alter Table "MyTable" ( modify streetnumbers Char(10) ) Interactive -----Original Message----- From: Sanna Sparr-Olivier [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 23, 2002 2:23 AM To: [EMAIL PROTECTED] Subject: MI-L join two columns? Hi! I have streetnames in one column and streetnumbers in another, is it possible to join them and have as a result one column containing the two of them? I'm using MI and MB 5.0. Thanks Sanna Sanna Sparr-Olivier Gis-Ingenj�r/GIS engineer Kart och M�tavdelningen Nyn�shamns kommun S-149 81 Nyn�shamn tel. +46 (0)8. 520 68196 ____________________________________________________________ _____ H�mta MSN Explorer kostnadsfritt p� http://explorer.msn.se/intl.asp ------------------------------------------------------------ --------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
