Forum Discussion
REPLACE(column, CHAR(160), '') unexpectedly clears entire string
We are observing critical and unexpected behavior when using the REPLACE function in Microsoft Fabric Data Warehouse. Specifically, when attempting to remove CHAR(160) (Non-Breaking Space) characters...
V-yubandi-msft
Community Support
Community SupportHi Rolandoc ,
Does the solution provided address your issue, or are you still experiencing the problem?
Your feedback is important to the community. If your issue has been resolved, please mark the response as Accepted Solution to help others find it more easily.
Thank you.
Just try NCHAR instead of CHAR.