sql autonumbering with comment

[Anon]

Againstmy wishes, my boss wants me to make a tablethat is not normalized. IE it will look like this:

productOne oldNumber
productOne newNumber

productTwo oldNumber
productTwo newNumber

how do I do auto numbering to draw a distinction between the two? Its going to be old/odd new/even, shoudl I just do my query based on if the ID is even or odd? Is it possible to add a letteror something to the ID, so the ID goes like 51Old, 52New, 53Old, 54New?

Thanks!!!!

[denvervender]

I agree with your solution, use a character subscript to your data. Maybe you would like to format it like N-51,O-51 to that in some cases that you have to query a product number you'll just strip the first two characters...