hi, can some one tell me how to merge input "fname" and "lname" and post to database to one coloum "name". thanks!

Question

hi, can some one tell me how to merge input "fname" and "lname" and post to database to one coloum "name".
thanks!

Answer 1

alter tableName
add name

update tableName
set name =
fname + lname

hope this helps

Answer 2

Can be use concate operator with white space place of + sign?

Answer 3

ok, thanks abiut it

Answer 4

this concat(fname+lname)