thank hou silvan..i got it...thanks...


>REPLACE ALL DialedNr WITH ChrTran(DialedNr, "-", "")
>
>HTH
>
>>a havea field named dialednr and contains phone numbers in this format
>>01541515161------
>>06551------------
>>14---------------
>>18448481881------
>>
>>how do i get rid of them for good not visually with chrtran dialednr,"-","")?