hi guys

i have my tax table,sss table
right now im using
case ..
sample code is
select case taxcode
           when 'z' then
                   case when grosspay between 417 and 1250 then grosspay0417*10+20.83
....

how can i replace this like lookup in exccl ,,let say that i will creat a tble then i will have to lookup this table to find the grosspay..
 hope u can help me..

tnx

Not sure I follow your question but simply link to the table. My understanding is thats all excel is doing. Give us some sample rows in the table you want to lookup if you want someone to give you the sql code for it.

i want to make a table (if possble) for ss..tax..

grosspay er
between 1000-12499.99 60.70
1250-1749.99 91
1750-2249.99 121.30
.
.
.
right now m using case statement
like select case when grosspay between 1250-1749.99 then 60.70
......

its very hard to maintain this case when i need to modify it.
can i create a table then look up its value to get the grosspay
hope this is clear
tnx for helping :)

Ok then a table is just what you want with values something like this below:

LowRange HighRange TargetValue
1000 1249.99 60.70
1250 1749.99 91.00
1750 2249.99 121.30

Then you want a SQL statement something like
select TargetValue where SourceValue >=LowRange and SourceValue <= HighRange
But you need to be sure you don't have overlaping values between the LowRange and the HighRange.