im sorry adding thre rates does not change because i need a net case..


>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..
>
>
>
>
>
>
>
>
>
>
>
>>>ed good morning, its working, but it needs a litle work more..
>>>for example call in a client thet is 411 calls...those do show upa at 0 dollars...thats goods.
>>>im thinking....using chrtran(dialednr,"-","") that replaces visually the dahes with blank...but how do i doit fisically in the database...?i know thats the problem..
>>>
>>
>>You know how to change the string, so all you have to do is save it; you have several things you could do, fixing the value before it's saved in the field would be one obvious solution, or at some point before processing the table after new records are added, you could use REPLACE to 'fix' the data fields. If the number of records involved in the table is large, you'd want to scope the REPLACE to only update records not previously processed, or if the number of records were fairly small (for example, if your import worked by pulling in new records to an intermediate file before putting them in their final resting place), something as simple as:
>>
>>USE MyImportTable
>>REPLACE ALL dialednr WITH CHRTRAN(dialednr, "-", "")
>>
>>would fix the field content in all the records.