What type of field should i use so that I can use integers like " 35-36" or even 35,36 and they are sorted as integers so that if I sort them they will be 1,11,33,40 NOT 1,11,2,22
You should use an INTEGER type. Set the size to the maximum size of expected values, like 6 if you expect 999,999 or less.
You can't store "35-36" in an INTEGER field.
You store one integer at a time.
Integers will sort correctly: 1, 3, 11, 33, etc.
