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.
| Author |
Topic |
|
wkm1925
Posting Yak Master
207 Posts |
Posted - 2010-02-10 : 01:09:48
|
| Let's say, i've 790311-56-4489444-8990-4800801129-68-8557how to remove - ? As a result, my resultset as follow79031156448944489904800801129688557 |
|
|
pk_bohra
Master Smack Fu Yak Hacker
1182 Posts |
Posted - 2010-02-10 : 01:11:49
|
| Use replace function...select replace('790311-56-4489','-','') |
 |
|
|
wkm1925
Posting Yak Master
207 Posts |
Posted - 2010-02-10 : 01:15:18
|
| tq sir |
 |
|
|
|
|
|