Haavard
Use Table menu - update column. Make sure you have a column in your
table with a field long enough to take the longest string of your two
fields together. (Use Table menu - table maintenance for this).
In Update column both table references should be your base table. The
column to update is the new column ( created above ) and the source
wants to be ltrim$(rtrim$(Field1)) + ltrim$(rtrim$(Field2))
The ltrim and rtrims are probably not needed as your fields probably
don't have spaces. However for "belt and bracers" leave them in!
Update column gets really powerful when you get data from a second
(relational) table - especially when the relationship is spatial!
Regards
Bob
In message <[EMAIL PROTECTED]>, Haavard Bgh-Olsen
<[EMAIL PROTECTED]> writes
>
>hello!
>
>
>How do I add charaterdata from to coloumns into one?
>
>example: the first column contains first_names (john)
>and the second coloumn contains second names
>(Smith)....I want the result to appear as JohnSmith in
>only one coloumn.There should be no space between John
>and Smith). There are tousands of records so
>I can't do this manually.
>
>thankyou very much!
>
>haavard
>__________________________________________________________
>Forlang service. Forlang kvalitet. Leveres hjemme hos deg!
>http://www.dressmart.no/
>----------------------------------------------------------------------
>To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
>"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
--
Bob Young
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
