Another approach , use an SQL statement and put results into a temp table.
When the SQL box comes up put any of the statements provided by others, such as PropStNumber + " " + PropStDir+" "+PropStreet (you may use quotes and a space instead of Chr$32)in the top section, delete the *, also put other fields you want in the temp table here as well, just don't use the *. You can also chose a column to order by such as street name, and you can give the temp table a name instead of "selection". From my parcel table I did a test combining the street number, direction and name, and using the parcel ID field as well. The map basic window from my trial shows this: Select PID, PropStNumber + " " + PropStDir+" "+PropStreet from Parcels order by PropStreet into Proprty_Addy William "Woody" Woodruff Zoning Administrator Charter Township of Union, Isabella County, Michigan (989) 772 4600 EXT 41 Visit our web site at http://www.geocities.com/ctuzoning/index.htm -----Original Message----- From: Vladimir Lashin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 23, 2002 1:28 AM To: Sanna Sparr-Olivier Cc: [EMAIL PROTECTED] Subject: Re: MI-L join two columns? Hello Sanna, Tuesday, April 23, 2002, 10:23:21 AM, you wrote: SSO> Hi! SSO> I have streetnames in one column and streetnumbers in another, is it SSO> possible to join them and have as a result one column containing the two of SSO> them? I'm using MI and MB 5.0. SSO> Thanks SSO> Sanna SSO> Sanna Sparr-Olivier SSO> Gis-Ingenj�r/GIS engineer SSO> Kart och M�tavdelningen SSO> Nyn�shamns kommun SSO> S-149 81 Nyn�shamn SSO> tel. +46 (0)8. 520 68196 SSO> _________________________________________________________________ SSO> H�mta MSN Explorer kostnadsfritt p� http://explorer.msn.se/intl.asp SSO> --------------------------------------------------------------------- SSO> List hosting provided by Directions Magazine | www.directionsmag.com | SSO> To unsubscribe, e-mail: [EMAIL PROTECTED] SSO> For additional commands, e-mail: [EMAIL PROTECTED] try this: select streetnames + "("+streetnumbers + ")" from streettable -- Best regards, Vladimir Lashin microOLAP Technologies LLC mailto:[EMAIL PROTECTED] http://www.microolap.com/gis/ - GIS related products --------------------------------------------------------------------- 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]
