Thanks Sergey, Kurt, Borislav

It was the linefeed I was looking at. Chr 10.

update landscapeplan set taxid = replace(REPLACE(taxid, char(10),''),char(13),'')

That update command cleaned everything right up.

Thanks guys for your help.

Quinn