wants to remove special characters from particular colomn in sql table

Question

I have one table which name is emp in this table one colomn which name is empname, there are more then 2000 employees , in this coloumn some names are like ' Avinash K. Odedra' it should be like 'Avinash K Odedra' , Now i wants to remove this special characters from it, Pls. Suggest me SQL Query for same.

Please show what have you tried – Hitesh Aug 19 '14 at 07:29 — Hitesh, Aug 19 '14 at 07:29

score 0 · Answer 1 · edited May 23 '17 at 12:13

0

This is not a particularly well formed question..

A quick google, with the words 'SQL Replace Special Characters', provided this similar question.

Looks like it might do what you need.

edited May 23 '17 at 12:13

Community

1
1

answered Aug 19 '14 at 07:29

askrich

598
5
20

score 0 · Answer 2 · answered Aug 19 '14 at 07:34

0

Please try the code below:

update emp
set empname = REPLACE(empname,"'","")

answered Aug 19 '14 at 07:34

Ethic Or Logics

111
1
13

score 0 · Answer 3 · answered Aug 19 '14 at 07:40

pls search your doubts before posting a question

removes special characters

DECLARE @str VARCHAR(400)
DECLARE @expres  VARCHAR(50) = '%[~,@,#,$,%,&,*,(,),.,!]%'
  SET @str = '(remove) ~special~ *characters. 3 5 from string 1 in sql!'
  WHILE PATINDEX( @expres, @str ) > 0
      SET @str = Replace(REPLACE( @str, SUBSTRING( @str, PATINDEX( @expres, @str ), 1 ),''),'-',' ')

  SELECT @str

wants to remove special characters from particular colomn in sql table

3 Answers3