My new db, on SQL Server, I have fields firstname and lastname separeted.
My old db, in Foxpro DBF, I have both concatened.

I do not want to change my code, just do a kind of adapter. Then, I did a remote views between SQL & Fox, used a function/expression to concatened the firstname and lastname. My question is how can I update fields separatly in SQL server from my view? Is exists a trick for that?