SQL how to update field with seq # starting with next #

I have file as follows:


Seq# CUST# name
------ -------- -------------
0000 0101 walmart
0000 0102 target

1234 0104 McDonalds
1235 0105 Burger King





I would like to run an SQL stmt to change all the seq zero fields to the next higher #, so when finished, file would look like:


Seq# CUST# name
------ -------- -------------
1236 0101 walmart <-------------------- seq# updated to next higher number
1237 0102 target <-------------------- seq# updated to next higher number

1234 0104 McDonalds
1235 0105 Burger King



Can SQL do this easily?

Thanks!



______________________________________________________________________
This outbound email has been scanned for all viruses by the MessageLabs Skyscan service.
For more information please visit http://www.symanteccloud.com
______________________________________________________________________