How do I remove non-breaking spaces from a column in SQL server?

q5iwbnjs 于 2023-11-16 发布在 SQL Server

关注(0)|答案(4)|浏览(125)

I'm trying to remove a non-breaking space ( CHAR 160 ) from a field in my table. I've tried using functions like RTRIM() to get rid of it, but the value is still there.

What do I need to do to remove the non-breaking space from the column?

sql-server

来源：https://stackoverflow.com/questions/15214848/how-do-i-remove-non-breaking-spaces-from-a-column-in-sql-server

4条答案

按热度按时间

v64noz0r1#

Try using REPLACE

UPDATE Your_Table
SET Your_Column = REPLACE(Your_Column, NCHAR(0x00A0), '')
WHERE Id = x

赞(0）回复(0）举报 2023-11-16

j5fpnvbx2#

You could also use

REPLACE(The_txt, NCHAR(160), ' ')

赞(0）回复(0）举报 2023-11-16

ufj5ltwl3#

If the above solutions does not work, try CHAR instead of NCHAR

UPDATE Your_Table
SET Your_Column = REPLACE(Your_Column, CHAR(160), '')
WHERE Id = x

CHAR worked for me.

赞(0）回复(0）举报 2023-11-16

ut6juiuv4#

NCHR(160) worked for me.

Oracle 19c.

赞(0）回复(0）举报 2023-11-16

我来回答

How do I remove non-breaking spaces from a column in SQL server?

4条答案

相关问题

热门标签

最新问答