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
thanks in advance,
Maged
Asked
Active
Viewed 8,351 times
-1
-
2I don't think there's a specific `remove` function, but maybe you can `replace` it with nothing. – GolezTrol Jun 19 '13 at 15:15
-
You cant expect to get help if you tried nothing. – OzrenTkalcecKrznaric Jun 19 '13 at 15:15
-
Have you tried the replace function ? – Laurent S. Jun 19 '13 at 15:15
-
possible duplicate of [How to replace a string in a SQL Server Table Column](http://stackoverflow.com/questions/814548/how-to-replace-a-string-in-a-sql-server-table-column) – HABO Jun 19 '13 at 15:26
