By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,481 Members | 3,078 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,481 IT Pros & Developers. It's quick & easy.

sequential numbers added to null fields

P: n/a
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
Jan 7 '08 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.