Just figured it out:

I used:

SELECT ASCII(RIGHT(MyString,1))

FROM dbo.tblWeirdChar

and the ASCII code was 160, which is a non-breaking space.

So, I used:

UPDATE dbo.tblWeirdChar

SET MyString = REPLACE(MyString,CHAR(160),'')

And it worked!

Sorry for the self-posting.

-Simon Doubt

DBA, Fulcrum Publications, Inc.