sequential numbers added to null fields

This is a strange one. Would anyone know of a strategy for querying a
table, looking for nulls in a particular field, then filling those
with a sequential number starting at the one after the last number.
e.g.:

Mr. Cohen 03/15/56 13244355
Mr. Rocco 07/15/75 13244356
Mr. Rice 09/01/61 13244357
Mr. Peterson 02/10/78 13244358
Mr. Holister 06/20/64 13244359
Mr. Drake 05/31/65
Mr. Kellspan 01/12/71

Thus how to (in a long series of records), take the two shown with a
null value and update with starting with 13244360, then 13244361, etc?
The number BTW is not the key field.

Thanks! Dave
.

Relevant Pages

  • Re: how to select or update data when column name has space
    ... That error sounds like your datatset that you are filling with the ... inserting nulls into it for every Company ID. ... Ryan eMVP" wrote: ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Difference between = and IN
    ... >I misunderstood what you meant in the previous post. ... >strange results if Nulls were present in the records whereas NOT ... (Remove _NO_ and _SPAM_ to get my e-mail address) ...
    (microsoft.public.sqlserver.mseq)
  • Re: VB Books in Australia?
    ... Aalaan wrote: ... It's very strange that querying for the following failed to turn ... Post replies to the group. ...
    (microsoft.public.vb.general.discussion)
  • page cant be displayed in ie6
    ... however its only filling it in half of the page.the rest of the page is fine. ... I tried netscape on the same link, ... I un-installed and re-install I.Explore,still the same. ... Hope this make sense.I know its strange. ...
    (microsoft.public.windows.inetexplorer.ie6.browser)