>>If I use an incrementing number as a surrogate primary key, why should I make it a character field? Tastrade does that
>
>Bret,
>
>You've heard some decent arguments for using an integer. If I had my guess, and memory still serves right, I'd say Tas didn't use them before is because there was once some trouble using integers together with combos. Integers would really confuse them.
>
>Steve
It would be more presize to say that integeres will require some accomodations with combos, and it's really doable.
Edward Pikman
Independent Consultant