UPDATE tablename SET fieldname3 = CONVERT(varchar(MAX), fieldname1 ) + ' and ' + CONVERT(varchar(MAX), fieldname2 )