When dealing with Unicode/nvarchar data in SQL, sometimes some unwanted characters can sneak into the database which may break things, or look wrong if you're not expecting them.
One example of this is if you use an XML serializer on data containing character 0x0B, it will throw an exception.
To find and replace this data, you need to use the BINARY collation as SQL will not find any characters outside of the normal set using the normal collations.
Example of a replace 0x0B:
MyField = REPLACE(MyField COLLATE
Latin1_General_BIN, NCHAR(11), '')