Hi,

Try, strtran('a 1',' ','') for text replacing.

Second, because you are using "Update {table} SET field= {value}"
It means updating all records. Please see SQL book.
So, if you just want to update some records. You can.

1. replace {field} with {value} for not (empty(.....
2. SCAN FOR not (empty...
replace {field} with {value}
3. update {table} set {field}={value} where .......
4.......

:) Wilfred

>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?
>
>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