You might want to put a space in between your streetname and number: ie.
Update MyTable Set NewColumn = streetnames+chr$(32)+streetnumbers regards Doug -----Original Message----- From: DPC [mailto:[EMAIL PROTECTED]] Sent: 23 April 2002 13:05 To: Sanna Sparr-Olivier; [EMAIL PROTECTED] Subject: RE: MI-L join two columns? 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] ________________________________________________________________________ This e-mail message (including any attachment) is intended only for the personal use of the recipient(s) named above. This message is confidential and may be legally privileged. If you are not an intended recipient, you may not review, copy or distribute this message. If you have received this communication in error, please notify us immediately by e-mail and delete the original message. Any views or opinions expressed in this message are those of the author only. Furthermore, this message (including any attachment) does not create any legally binding rights or obligations whatsoever, which may only be created by the exchange of hard copy documents signed by a duly authorised representative of Hutchison 3G UK Limited. ________________________________________________________________________ --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
