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 |
|
chava_sree
Yak Posting Veteran
56 Posts |
 Posted - 2008-04-28 : 20:35:43
|
| I am trying to Strip off the Numbers witha Delimited List and just retain the Name of the Persons. but unable to do it. is there any function or code to do that in SQL932908` James Fleser,935992` Prakash SinhaStripping off Numbers for the Above and Just retain the Names..thanks |
|
|
chava_sree
Yak Posting Veteran
56 Posts |
Posted - 2008-04-28 : 20:48:26
|
| just to add up the above Problem, am getting a column with those multiple values, so not sure whether i loop thru the column..or not |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-29 : 00:15:48
|
| http://sqlblogcasts.com/blogs/madhivanan/archive/2007/12/18/extract-only-numbers-from-a-string.aspx |
|
|
|
chava_sree
Yak Posting Veteran
56 Posts |
Posted - 2008-04-29 : 02:42:24
|
| visakh i said stripping off number.. so do you mean i just replace [a-z] instead of [0-9] |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-29 : 02:48:17
|
| Yup...or just change like to not like |
|
|
|
|
|
|
stripping off numbers in a list