Forum Discussion

Rolandoc's avatar
Rolandoc
Regular Visitor
1 year ago

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...
data warehouse
warehouse
V-yubandi-msft's avatar
V-yubandi-msft
Icon for Community Support rankCommunity Support
1 year ago

Hi Rolandoc ,

Thank you for posting your query in the Microsoft Fabric Community. Before submitting a support ticket, it may be useful to try a simple workaround by using binary collation. This instructs the engine to compare strings byte for byte, which can help avoid issues caused by special characters like CHAR(160). Please check if this resolves the problem.

If the problem persists or you’re seeking a more permanent solution or official confirmation, as lbendlin , suggested, it’s advisable to raise a support ticket for deeper investigation.

 

You can also refer to the official documentation here: CHAR (Transact-SQL) - SQL Server | Microsoft Learn

 

— Yugandhar
Community Support Team.