Work Breakdown structure and normalization

[Paolo]

Hi,

I'm working with work breakdown structure codes: 1.0.1.123 or 1.23.32,
etc that seem to be very difficult to sort as text. So I broke them
down and converted them to integers into an array so that 1.0.1.123 as
text became

Array(0) = 1
Array(1) = 0
Array(2)= 1
Array(3)=123

as integer

Then I took the integer array and appended a table with its values and
sorted that way.

So on one table I have

Field 1 Field2 Field3 Field4 Field5
1.0.1.123 1 0 1 123

And Another table I have

Field 1 Field 2 Field3 Field4
1.0.0.123 More pertinent stuff etc.......

Obviously these two tables have a 1 to 1 relationship. Am I violating
any major laws of database design by going this way? Is there a better
way?

Thanks
Paolo

(e-mail address removed)

 

[Paolo]

Thanks Jamie,


Appreciate the response.


Paolo

(e-mail address removed)