update field using to other fields?

[KashKurcura]

Hello:

I'm trying to update my database table, I have fields called Name (new field), FName, LName. Is it possible to write a query that will update 'Name" joining the FName and LName together?

Update 'Users' SET Name = FName LName

Does not work.

[laserlight]

You might want to learn about database normalisation

[KashKurcura]

HUH? I just want to know if it is possible to update that feild using two other fields.

Does anyone know how this can be done?

"Update 'Users' SET Name = FName" will update Name with the FName but i need the LName in there too.

[tsinka]

Always put single quotes around the values you assign to a field

Update Users SET Name = 'FName LName'

Thomas

[pascaltje]

It's possible, you have to make a join in your SQL query, something like:

UPDATE Users A LEFT JOIN Users B ON A.Users_id = B.Users_id SET A.Name = B.FName +' '+B.LName

A+