the hard-coded numbers were inserted by me as I added items in the columns. The Spanish column does allow nulls, but the primary key 'ID' certainly does not. The problem is that the insert statement added the values and there werent't any hardcoded 'IDs' for those values. However I am trying to get those values into the existing fields for the Spanish column where numbers already exist and the Spanish field is empty. Is there some kind of loop from 1 to ... with an update statement or sth I can do?