Hi

I need some advice on adding a certain table into an SQL/Windows client. The table looks something like this:

1 2 3 4 5 6

1<x<=2 4.0 2.0 5.0 3.4 6.7 4.7

2<x<=5 3.0 2.3 4.5 3.4 5.1 6.0

The table works in this way. Suppose the variable is y on the top of the table i.e. y = 1,2,3,4,5 or 6. If I have two values y = 3 and x = 1.3, then the table would give me the answer 5.0

My questio comes in two parts, firstly, what is the best way for me to add this type of table to an SQL database. Secondly, what would be the best way to interogate the database to get the answers for a given value of x and y?

Thanks in advance

John

The data would look something like

Y minX maxX Value

1 1 2 4

2 1 2 4

3 1 2 4

1 2 2 4

2 2 2 4

3 2 2 4

You could query this table with a condition similar to:

WHERE Y=myYValue AND myXValue BETWEEN minX AND maxX

You just have to be careful with the minX and maxX values, so they don't overlap and return only one value for every X number.

Regards,