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]
