Update Query - Update column value with data from another column

[gust1480]

Hi,

Can somebody please teach me on how to update a certain column value using another column value?

Ex. I need to get the value from acct field then update the value on the name and country using the value from the acct field and at the same time appending the field name with it.
From

Acct Name Country
FAR John USA
ARD Pier FRANCE
MDO Ming CHINA

To
Acct Name Country
FAR FAR-Name FAR-Country
ARD ARD-Name ARD-Country
MDO MDO-Name MDO-Country

Thanks

 

[feherke]

Hi

Unless there is a trap I missed, should be simple as :

[b]update[/b] thetable
[b]set[/b] Name = Acct + [green][i]'-Name'[/i][/green], Country = Acct + [green][i]'-Country'[/i][/green]

But I feel would have more logic to request something like this :

[b]update[/b] thetable
[b]set[/b] Name = Acct + [green][i]'-'[/i][/green] + Name, Country = Acct + [green][i]'-'[/i][/green] + Country

Or actually you have an unknown number of fields and actually you want to automate generating the [tt]update[/tt] statement ?


Feherke.
feherke.github.io

 

[gust1480]

Hi Feherke,

No trap.

Thanks!