>I want my results to have 1,2,3...99 in one of the fields. I thought there was a field type that would allow me to do this, but I can't seem to locate it.Do you mean Identity field?
You start it wihth a seed (default = 1) and an increment step (default = 1). It's an int type and cannot contain nulls.
Normally used for surrogate PKs.