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)
 How to remove - character in string

Author  Topic 

wkm1925
Posting Yak Master

207 Posts

Posted - 2010-02-10 : 01:09:48
Let's say, i've

790311-56-4489
444-8990-4800
801129-68-8557

how to remove - ? As a result, my resultset as follow
790311564489
44489904800
801129688557

pk_bohra
Master Smack Fu Yak Hacker

1182 Posts

Posted - 2010-02-10 : 01:11:49
Use replace function...
select replace('790311-56-4489','-','')
Go to Top of Page

wkm1925
Posting Yak Master

207 Posts

Posted - 2010-02-10 : 01:15:18
tq sir
Go to Top of Page
   

- Advertisement -