Code:
UPDATE MASTNAME
   SET LNAME = ''
WHERE LNAME = 'NONAME'