Yep, dropped back to VFP, glad it worked.

>Hi Neil, I take it you meant char(10) not chr(10) ? Anyway what I did was this
>
>

>update mytable
>set myfield = replace(replace(myfield,char(10),''),char(13),'')
>

>
>thanks for pointing me in the right direction - it worked a treat.