"Swayze, Natalie: #PNWT - PTNO" <[EMAIL PROTECTED]> wrote: > I have a table that has 2 columns:one with "Str_name" and one with > "Str_num". I need to combine the info. into one column( i.e. full address), > with a single space between the number and name. What is the appropriate > method of doing this with MI? Natalie, Through Table > Maintenance > Table Structure, add a New Column and call it Address. Click on OK to get all of the way back out. Now, use Table > Update Column. Select the table that you are updating. The column that you are updating is "Address". Get Value from Table (same table name as the one you are updating). For the Value, hit Assist. Your entry should be: Str_num+" "+Str_name You can use the Columns pulldown to help you add your field names. Good luck! ...And don't forget to hit the Verify button on your way out. Jo Jo Jordon Consulting MapInfo Certified Instruction Vertical Mapper Certified Instruction GIS Consulting www.geocities.com/jordonjv [EMAIL PROTECTED] ____________________________________________________________________ Get free email and a permanent address at http://www.netaddress.com/?N=1 ---------------------------------------------------------------------- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
