>Hi All,
>
>Is there a way to put into a SQL - Select statement a number that increments by 1 and resets at when a value changes? For instance an incrementing number that resets at each zip code.
>
>Aloha,
>
>James
In principle no, because you have no control in which order the records will be processed. However, if you do a first SELECT into a cursor (with the NOFILTER clause), then it is likely that SELECTing from this cursor will process the records in order. In this case, I would create a UDF, which accepts the key field as a parameter, increments a global variable or a value in a table, and resets when the value changes.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)