You might also want to save an "Alter table" by using Update MyTable Set NewColumn = streetnames+chr$(32)+str$(streetnumbers)
Regards Uffe Kousgaard ----- Original Message ----- From: "Douglas Cubin" <[EMAIL PROTECTED]> To: "'DPC'" <[EMAIL PROTECTED]>; "'Sanna Sparr-Olivier'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, April 23, 2002 2:17 PM Subject: RE: MI-L join two columns? 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 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
