Convert Select into update

Question

is there any way to convert this into SELECt query to UPDATE?

SELECT p.pId, p.Lname, p.Fname, i.pId, i.iId, i.fatherID, i.motherID, i.DateOfBirth, i.Address,     (SELECT sp.Fname+' '+sp.Lname FROM Profile sp WHERE sp.pId=i.pId) AS child,     (SELECT sp.Fname+' '+sp.Lname FROM Profile sp WHERE sp.pId=i.fatherID) AS father,     (SELECT sp.Fname+' '+sp.Lname FROM Profile sp WHERE sp.pId=i.motherID) AS mother         FROM Info i             INNER JOIN Profile p                 ON p.pId=i.pId

but code above is used within ASP, what I need for now is to convert that into UPDATE which will I use inside my c# code, which I need to declare variables such as @pid, @lname...please help me...Thanks and Godbless