Yet another way that I have not seen mentioned, but avoids having to create a permanent new column or a temp table:
Open a browser window on the table and choose Browse>Pick Fields Here you can add a new computed column by choosing "expression..." from the list and entering in any of the below mentioned formulas. Regards, Chris Chris DuBuc Sage Software Atlanta GA & Orlando, FL [EMAIL PROTECTED] www.sagesoft.com ----- Original Message ----- From: "Woody Woodruff" <[EMAIL PROTECTED]> To: "Mapinfo List" <[EMAIL PROTECTED]>; "Vladimir Lashin" <[EMAIL PROTECTED]> Sent: Tuesday, April 23, 2002 12:32 AM Subject: RE: MI-L join two columns? > 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] > > --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
