Well, yes. You probably have a string field for that content, right? so the content is being compared as strings, not as numbers, that why something like 1000 is lower than 2. Leading zeros would be an option. Another option is to separate the field into numeric fields and sort by those (this last option is only recommended if your data always look similar). Something like 11C15 to field1: 11, field2:C field3: 15. Then use "sort=field1,field2,field3".
Anyway, both this options require reindexing. Regards, Tomás On Fri, Oct 21, 2011 at 4:57 PM, Peter Spam <ps...@mac.com> wrote: > Hi everyone, > > I have a field that has a letter in it (for example, 1A1, 2A1, 11C15, > etc.). Sorting it seems to work most of the time, except for a few things, > like 10A1 is lower than 8A100, and 10A100 is lower than 10A99. Any ideas? > I bet if my data had leading zeros (ie 10A099), it would behave better? > (But I can't really change my data now, as it would take a few days to > re-inject - which is possible but a hassle). > > > Thanks! > Pete >
