Re: Help with look up table
Isaac, I think I would do it this way, eliminating the AND in each of the statements by using a CASE statement. I also notice there is no compare for the value of 389. Is this intentional?
select case datax
case is < 323
pressure = 999
case is < 326
pressure = 0
case is < 329
pressure = 25
case is < 332
pressure = 50
case is < 337
pressure = 75
case is < 340
pressure = 100
case is < 343
pressure = 120
case is < 347
pressure = 140
case is < 352
pressure = 160
case is < 356
pressure = 180
case is < 361
pressure = 200
case is < 365
pressure = 220
case is < 371
pressure = 240
case is < 376
pressure = 260
case is < 380
pressure = 280
case is < 388
pressure = 300
case is > 389
pressure = 999
end select
Dave Purola,
N8NTA
EN82fn
Bookmarks