Roman Numerals

[TLATELOLCO2000]

Does any one know if there is a way to sort Roman Numerals? I tried sort but it messes them up. If sorted correcty it should show the following.

I 1

II 2

III 3

IV 4

V 5

VI 6

VII 7

VIII 8

IX 9

X 10

When it's sorted it shows something like this:

I

II

III

IV

IX - Out of sequence - 9

V

VI

VII

VIII

X

I have up to 100 in Roman #'s.

Please Help.

Thanx in advance

[Kurt Knippel]

quote:

---

Originally posted by TLATELOLCO2000:

Does any one know if there is a way to sort Roman Numerals? I tried sort but it messes them up. If sorted correcty it should show the following.

---

Create a value list with the proper order and use that value list for sorting OR you can make a field with the normal integer equivelant and sort by that field, which is much easier than the other option.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Consultant

Database Resources

mailto:[email protected]

http://www.database-resources.com

=-=-=-=-=-=-=-=-=-=-=-=-=