Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
2 fields fusion
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00776942
Message ID:
00776945
Views:
20
This message has been marked as the solution to the initial question of the thread.
REPLACE field3 with ALLTRIM(Field1)+" "+alltrim(field2) ALL

>I have a table made in a weird way
>
> The guy built 2 small fields
>
> eg.
> Field 1: "I am afraid"
> Field 2: "of ghosts"
>
> How can I make a fusion of this 2 fields in one new field
> and keep a space of a digit between the frases
>
>"I am afraid of ghosts"
>
> The table has over 10,000 records
>
> Moises
Dominican Republic, a Paradise in America
Previous
Reply
Map
View

Click here to load this message in the networking platform