how do i write one case for
if the numebr is less than 7 digits but is not 411 or 911...
to giveme 0.0







>>i found another problem..
>>looking at the database calls made to local area toll like
>>954,564,305,do not have a one in front.....
>>so how can i put another do like if dialednr is 7 characters long
>>take only the the number one plus the first three digist of the call...
>>or better yet i aded another three records to the rates table with 305,954,561..and that solved it..
>>but still my calls do not show up in my grid, the show up once i get to that page but the desapear..
>>
>
>Take a look at what i did for 411 and 911, and use those as a model for what needs to be done. Again, the DO CASE...ENDCASE is forcing things not to be looked up if they don't meet your set of acceptable prefix criteria; simply adding records isn't going to work if you don't allow for the number to be picked up in lcSeekValue in the DO CASE...ENDCASE.
>
>It's all the same problem.