I have an SQL database which holds 1500 records. One of the fields in each record is a registration number - S1W8E7D9E1N. I need to write a query that will allow me to append and increment numbers 25-1525. So the field in the first record would be S1W8E7D9E1N25, second would be S1W8E7D9E1N26 all the way to 1525. I'm in a little hot water here. I need to accomplish this today. All HELP would be appreciated!!!!!