How to remove the character '%' from string in sql

Question

I have a nvarchar column in a table that contains the character % in its text. I want to remove or substring this character from this text. Is there any way to do that?

I don't think there's a specific remove function, but maybe you can replace it with nothing. — GolezTrol
– GolezTrol, Commented Jun 19, 2013 at 15:15
possible duplicate of How to replace a string in a SQL Server Table Column — HABO
– HABO, Commented Jun 19, 2013 at 15:26
Does this answer your question? How do you strip a character out of a column in SQL Server? — MB_18
– MB_18, Commented Apr 17, 2022 at 8:05

Kenneth Fisher · Accepted Answer · 2013-06-19 15:15:29Z

9

UPDATE TableName SET ColumnName = REPLACE(ColumnName,'%','')

answered Jun 19, 2013 at 15:15

Kenneth Fisher

3,82221 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jeremy Caney · Accepted Answer · 2022-06-28 00:29:44Z

0

If you want it from the query, then you can do this

SELECT REPLACE(columnName, '%', '') AS TrimmedValue

edited Jun 28, 2022 at 0:29

Jeremy Caney

7,798115 gold badges58 silver badges87 bronze badges

answered Jun 27, 2022 at 6:49

Junaid

1

Collectives™ on Stack Overflow

How to remove the character '%' from string in sql

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related