Ranges

[dcarr]

I am developing a table that contains a series of values both text and numerical based.
In one of the fields CLASS_RANGE I want to specify a range that an item can be associated with. Is the following syntax the correct syntax to use:

CLASS_DESC RANGE
========= ========
local 255-430
fdc 431-500

Or do I need to specify the criteria dfferently???

Hope this makes sense??

 

[Fizzio]

You may be better off using 3 fields. depending if you want to query a particular item in a range - makes it more robust and easier to change.

eg
tblYourTable
---------------
RangeDescription ie local
RangeLower ie 255
RangeUpper ie 430

 

[dcx693]

I agree with Fizzio, you are much better off using three fields. You should always break down the information stored in your database into the smallest logical pieces.

If in the future, if you try to determine what class something has given a number within a range, it will be much easier with the lower and upper ends defined.