I am trying to identify the best column type to store a selection of number values and ranges of number, e.g. 10,000-20,000. A majority of the values will be individual numbers but some need to display the range. Is this possible to do in any way other than creating a 'text' column?
It seems a shame to lose the ability to deal with numbers numerically.