Hi,<BR> I am a novice to SQL. It will be great if someone can go thro&#039 my question.<BR><BR>I have a table. the table has three columns, CustomerName,totalads,totalIncome<BR><BR>I am trying to insert a record into this table.<BR><BR>If the particular CustomerName is already found , I just need to update the other two columns totalads,totalIncome.<BR><BR>If the CustomerName column is not found, then I need to insert a whole new row.<BR><BR>Also, I need to use the lock options in the table, so that no two users can try to update the table at the same time.<BR>how will I do this?<BR><BR>Any help will be appreciated.