Horton

Thread

  1. help with UPDATE sql

    Kevin Heflin <kheflin@shreve.net> — 1999-03-15T05:07:06Z

    Could some one offer a suggestion on the following.
I have a table of customer information. One of the fields of type int has
the value of a number 1-30.

Currently they are all set to either 10 or 20
I would like to be able to run an update statment, which will fill this
field with 1, then on the next row, 2, then 3, etc then 30, then start
back over at 1

Any suggestions would be appreciated.

Kevin



--------------------------------------------------------------------
Kevin Heflin          | ShreveNet, Inc.      | Ph:318.222.2638 x103
VP/Mac Tech           | 333 Texas St #619    | FAX:318.221.6612
kheflin@shreve.net    | Shreveport, LA 71101 | http://www.shreve.net
--------------------------------------------------------------------