>Hi all,
>
>I want to change the string 'a 1' to 'a1'. I have tired it with alltrim() method but it cannot work. any other functions can do it?

strtran() or chrtran()

>
>For scan...endscan. I guess it is search reccord one by one. i have the following code:
>proc co_test
>use "c:\ccs program\conversion\cbpo\company.dbf"
>
>
>local cor_cbpol
>local cor_cbpom
>local cor_cbpos
>
>
>scan
> if empty(alltrim(co_refl))=.f. and empty(alltrim(cbpo_refl))=.t. lower
> > update company set cbpo_refl='abc'
> endif
>
>endscan
>retu
>
>I just want some particular records which fullfil the condtion to be updated but all records are updated? why?
>
>Linda