Numeric Column Type

Michael Smith

Has anyone noticed that the alpha/numeric column doesn't sort properly when numbers are in the following format: 1.5.1.1, 1.5.11.2...........11.5.11.40. You get this:

 

1.5.11.1

1.5.11.10

1.5.11.11

...

1.5.11.2

1.5.11.20

1.5.11.21

.......

1.5.11.3

1.5.11.3

1.5.11.31

...

 

Would a purely numeric column type take care of this sort issue?

Brett Evans

You have to include leading zeros in each decimanl place if you want this to sort properly.

So this,

1.5.11.1

1.5.11.2

 

Would become

1.5.11.01

1.5.11.02

 

 

Thanks,

Brett