How can you change “Hansen” into “Nilsen” in the “LastName” column in the Persons table?

Question

How can you change &ldquo;Hansen&rdquo; into &ldquo;Nilsen&rdquo; in the &ldquo;LastName&rdquo; column in the Persons table?

Admin · Accepted Answer

UPDATE Persons SET LastName=&rsquo;Nilsen&rsquo; WHERE LastName=&rsquo;Hansen&rsquo;

Admin · Answer

UPDATE Persons SET LastName=&rsquo;Hansen&rsquo; INTO LastName=&rsquo;Nilsen&rsquo;

Admin · Answer

MODIFY Persons SET LastName=&rsquo;Nilsen&rsquo; WHERE LastName=&rsquo;Hansen&rsquo;

Admin · Answer

MODIFY Persons SET LastName=&rsquo;Hansen&rsquo; INTO LastName=&rsquo;Nilsen&rsquo;

Q. How can you change “Hansen” into “Nilsen” in the “LastName” column in the Persons table?