How to look values between variables
Hello all,
Been looking but no luck. The scenario is this:
if variable is 1 to 9 then Unitcost 1
if variable is 10 to 99 then Unitcost2
if variable is 100 to 499 then Unitcode3
if variable is 500 to 10000 then Unitcost4
the Unitcost is built up of four columns in sql.
Thanks in advance.
|
