SQL: update column with a sequential #

Is it possible to update a column with a sequential # ?

So that for this particular column, each row has a value 1 higher than the prior row?

Something like

UPDATE filename set SEQCOL to prior SEQCOL + 1

(This is a DDS created file that does NOT have an identity column.)

Thanks!

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