Remove special characters - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Remove special characters

Author

Topic

sqlpal2007
Posting Yak Master

200 Posts

Posted - 2009-11-18 : 07:31:22

Hello All,

How woudl I remove special characters and spaces from a string? I have to update a column by removing the spaces and special characters like -, %, #, _ etc.

Example - Part# column

RE34-Y 2 should be RE34Y2

Any help would be appreciated.

Thanks,
-S

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-11-18 : 07:35:19

Use multiple replaces

update table
set col=replace(replace(replace(col,' ',''),'-',''),'#')

Madhivanan

Failing to plan is Planning to fail