i actually put what you just gave me and i thatnk you for that..
what i dod to test all this function i i put it in the report but it gives me for all the records 0......there is something wrong..what could it be..
>>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
>>
>
>Put the 411 and 911 code that works in before this, and add this after them, but before the OTHERWISE. The DO CASE...ENDCASE is processed sequentially top to bottom, and you fall out of the block once you've satisfied a condition tested by a CASE.
>
>
CASE LEN(ALLTRIM(CHRTRAN(view1.dialednr, '-',''))) < 7
> lnResult = 0