Re: Database design question

I'd have to see that second rule in context and with further explanation.
Like, where did you get that from? Until I see that I'll hold off on
judging it.

Now, if you are a software shop you may have some flexibility due to
software migrations. For example, one vendor use a character field for
their customer number but to initialize it they only used an incrementing
number. The reason it was character was in case you were migrating from a
different package they did not want to discourage you from migrating to
their package because your existing package used a character field. In
theory, yes you could have used the migration as a time to clean that up.


Rob Berendt