>>>I didn't know that NUMERIC can be Identity. I actually need only 4 or 5 digits at the most for this column (the numbers never will go > 10000). Thank you very much.
>>
>>In the old days (when I was writing code generators for 2.6) I intentionally kept the customer code to 4 digits. I'd explain it to my customers as something that's short enough for their operators to memorize (that was before combos, and before I wrote the incremental search routine), and "and if you ever get more than 9999 customers, you'll send your limo and the driver to pick me up, and I'll widen the field for free".
>>
>>Notice how I avoided saying "it will never". Because each time I said that, I'd later bite my tongue. And when a customer would say it, I'd write it down as a comment in code, and show it to them later with a "what did I say?" ;).
>
>We all learn from our mistakes. Otherwise, MS would still be selling Window 3.0 :)
You mean, everyone learns from their mistakes, MS doesn't? :)