>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
MyImportTableREPLACE ALL dialednr WITH CHRTRAN(dialednr, "-", "")
would fix the field content in all the records.
