SQL format types

Question

What if I need to store intervals like 5-10 or 100-500? What kind of type should I use? And another one is how to store values like 5*108, 5/108? Should I use string format?

Thanks

Answer 1

Denis Kolesnikov

Yes in this case you should use VARCHAR otherwise make 3 columns for each value for example: minValue, Seperator, maxValue.

But I think 1 column is enough which will be String format