title: SQL Replace Into question
body: <p>With Replace Into, if I have two fields.  FirstName LastName.  The table has John Smith in it, if I was to run REPLACE INTO tblNames (FirstName, LastName) VALUES (John, Jones)
  Would that replace Smith with Jones, or create a new name?</p>
  
  <p>What determines if its an Update or and Insert?</p>