Proper sorting by number

richtestani · 2010-04-05 21:37:52

I’m working with a collection of articles which I want to sort from a custom field.
The values in the custom field are integers.

Sorting on this results in:

1
10
11
12
13
2
21
22

How can get I get proper sorting?
Thanks
Rich

Gocom · 2010-04-05 22:32:49

Results are sorted as strings, because the field type is varchar. You might get past it by trying something like:

sort="(custom_1+0) asc"

Hope it helps.

Textpattern CMS