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.