* insert just befor the OTHERWISE clause CASE LEFT(view1.dialednr,3) == "411" && the dialed number was 411 * 411 calls cost $0.75 each lnResult = .75 CASE LEFT(view1.dialednr,3) == "911" * 911 calls cost $10 each lnResult = 10.00You can continue this approach for as many things as you need; this change forces the rate for specific numbers If you needed to handle things to do lookups in the rate table rather than hard-coding the rate as shown, you could change the code to set the lcSeekValue, forcing a lookup.
* alternative to test second and third character and * force a 3 character lookup CASE SUBST(view1.dialednr, 2, 2) == '11' * take the first three characters if the 2nd and 3rd are "11" * and a previous case didn't handle the number already lcSeekValue = LEFT(view1.dialednr,3)>can you please help me correct this.....i know tht is halfway working..