>>>I have a table with address lines where many of the blank characters are in fact ascii(160) how do I get rid of them
>>>
>>>Thanks
>>>
>>>Colin
>>
>>

lcString= chrtran(lcString,chr(160),'')

>
>brilliant thanks Tore

You're welcome. You can also use strtran(), where you can remove (o replace) more than one character.

lcString= strtran(lcString,chr(160)+chr(161),'')