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 2000 Forums
 Transact-SQL (2000)
 to eliminate space and special characters

Author  Topic 

henryhan
Starting Member

1 Post

Posted - 2009-05-14 : 23:09:57
Hi,

I need to truncate white space and special characters in a string.

example:-

H1-10U^K*89#2009 (25001TD)

INTO

H110UK89200925001TD


So how can I manage the above in my Stored Procedure?

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-05-15 : 01:58:30
http://sqlblogcasts.com/blogs/madhivanan/archive/2009/05/11/removing-unwanted-characters.aspx

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -