sorting query output with Romal Numeral (sorted alphabetically)

[lizok]

Hello, i need some help.
i have a query that outputs this one column that (note: 602.16(a)(1)(i) is data in column, not concatinated data):
602.15(a)(4)
602.15(a)(5)
602.15(a)(6)
602.15(b)
602.16(a)(1)(i)
602.16(a)(1)(ii)
602.16(a)(1)(iii)
602.16(a)(1)(iv)
602.16(a)(1)(ix)
602.16(a)(1)(v)
602.16(a)(1)(vi)
602.16(a)(1)(vii)
602.16(a)(1)(viii)
602.16(a)(1)(x)

Please note that it sort but when i have Roman numeral, they are sorted alphabetically: iv,ix,v and it should be iv,v,ix. Is there a way to sort it correctly.

 

[gmmastros]

Here's a site that claims to give, free of charge, udf's that can convert to/from roman numerals.

http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=502&lngWId=5

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[Persmd]

You might also look at this thread:

http://tek-tips.com/viewthread.cfm?qid=1078647&page=1

I feel a lot more like I do now...
than I did when I first got here!

Michael