AnsweredAssumed Answered

Curious SORT fix

Question asked by firth5 on Jan 25, 2010
Latest reply on Jan 25, 2010 by philmodjunk

Title

Curious SORT fix

Post

In my database I have a field which has several options in it's pull down menu:

 

(I'm not going to go into details about why this data is what it is)

 

0

Couch

Flyby

I

II

III

IV

 

I've automated the SORT so that it will sort by value list order.

 

Problem is, the file doesn't seem to recognize any difference between I, II, III and IV.  If I change them to be 1, 2, 3, 4, the data sorts properly.  

 

It's not that big a deal to have it be 1, 2, 3, 4, but I'm curious WHY the roman numerals wouldn't work.  Any thoughts? 

Outcomes